Monday, December 1, 2014

Excel Macro with Loop to Repeat actions

If you have a repeating series of actions (such as inserting a label 12 times) then you can add a Loop to an Excel macro. Just record you macro as you need then at the start of the repeating step put:

For i = 1 to 12

then your recorded code

Next i

This will make the Excel macro repeat 12 times. Excel training Toronto Mississauga Hamilton Ontario can help you with this and other Excel functions. Note "i" is used here but any word will do.

Bert Twomey
MS Office & Excel training
Toronto, Mississauga, Hamilton Ontario
905-271-1119