Solved

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

Posted on 2011-03-21
4
205 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 500 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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

726 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