Solved

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

Posted on 2011-03-21
4
202 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
  • 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel If Statement to return a value 5 21
Highlighting cells in Excel 9 16
macro for closing opened workbook 6 19
Help with Excel formula 6 35
Drop Down List with Unique/Distinct Values (enhancing the Combo-Box with a few steps and a little code) David miller (dlmille) Intro Have you ever created a data validation list from a database field or spreadsheet column (e.g., Zip Codes or Co…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now