• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

Macro that will iterate all the numbers within a range, such as 931-938

I got a great function from zorvek last week that does just that through use of an array. But  the array causes me some problems elsewhere in the workbook. So I think I really need a macro to do this.

I've been working on it for more time than I want to admit, and i Just can't firgure it out. Please take a look at this workbook and correct my code if it's salvagable, or give me another direction if it's not.

Right now I just want to be able to parse the cells with only one range defined in them. Then we'll move on to the more complicated part.

Thanks,
John


FindNumbers2f.xls
0
gabrielPennyback
Asked:
gabrielPennyback
  • 3
1 Solution
 
zorvek (Kevin Jones)ConsultantCommented:
Geez! Who the hell wrote THAT code? Let me see if I can save your bacon...again.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
ZZTop? You be inhaling the hooch again?
0
 
zorvek (Kevin Jones)ConsultantCommented:
All better now.

Kevin
FindNumbers2f.xls
0
 
gabrielPennybackAuthor Commented:
Kevin, I should be ashamed of myself. Oh, wait aminute ... I forgot ... I AM ashamed of myself. not for being stupid (well, that too), but mostly for having wasted so much time on this today.

Thanks, Kevin.

- John
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now