Macro help

[MacroHelp0123]

Hello,

If I want to run a macro down multiple rows of data (sort of like autofill, but with running a macro), how would I do this? For example, lets say I want to copy A2, paste into a calculator on another tab, then copy and paste the output from the calculator onto a a different tab...how would I tell the macro to keep doing this running down the rows until there is no more data (A3, A4, A5, etc)?

Hopefully, I explained this well. Thanks in advance for any help

 

[Alan_P]

Hi MacroHelp0123,

You'll need a loop to do that, have a look at this site it explains it pretty well...

Excel VBA Loop - Easy Excel Macros

Cheers,
Alan.

 

[MacroHelp0123]

Thank you Alan!