?
Solved

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

Posted on 2011-03-21
4
Medium Priority
?
206 Views
Last Modified: 2012-05-11
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
Comment
Question by:gabrielPennyback
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35186006
Geez! Who the hell wrote THAT code? Let me see if I can save your bacon...again.

Kevin
0
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 35186009
ZZTop? You be inhaling the hooch again?
0
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 2000 total points
ID: 35186061
All better now.

Kevin
FindNumbers2f.xls
0
 
LVL 1

Author Closing Comment

by:gabrielPennyback
ID: 35186161
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question