-
How to DIM script itself?
Excel Version: MS Office Professional Plus 2013
I am writing a macro that uses the same function "Cells(firstRow + j - 1, firstColFinal)" multiple times.
firstRow and firstColFinal are dynamic values, and j is from a For loop.
Is there a way to define a part of the script as "DIM X as Script" and simply put "X" in the code instead of this longish Cell(#,A)?
Or would I need to type this out each time I need to use it?
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules