Solved Macros that repeat until the endof data set has been reached

July 1, 2016 at 10:44:10
Specs: Windows 7
How to I record a macro to go fetch a line of data from one sheet, enter it into another, then repeat until all the data from the source sheet has come to an end, i.e. you have reached the final row in the source sheet

See More: Macros that repeat until the endof data set has been reached

Report •


#1
July 1, 2016 at 20:59:46
✔ Best Answer
You can't record that type of macro, you have to write it out manually. The recorder does just what it is "defined as" - records the actions you perform in the spreadsheet.

You'll probably need to use a For-Next loop, e.g.

For myRow = 1 To 1000
   ...Insert repeatable instructions here...
Next

If you'll provide a few more specifics as to what you are trying to do, we 'll see what we can do to help you out.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question