[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2011-03-21
4
Medium Priority
?
208 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: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

650 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