Hi guys,
This question is in regards to the following macro (It does work on my worksheets).
Please Login or Register to view this content.
The two parts highlighted in red need to be changed often to other formulas and then have the macro run on many different columns (achieved by changing Num1).
QUESTION: Is there a way I could move these two highlighted red bits to the beginning of the macro or have them easily accessible. Or does someone have a better or smarter way to do this? Ideally I would place them both near where the "Num1" at the start of the code. (See where the XXX is)
The only solution I can think of is something like the following, using "goto" which would be very slow to run and does not seem like a clean solution.
Thanks,Please Login or Register to view this content.
Jimmy
Bookmarks