Macro to copy column of data and call a sub-procedure

[kent97]

ScreenHunter_001.jpg

I want to write a macro:

1. The macro starts at Cell A1
2. Copy C1:C4 to A1:A4
3. Call and run a sub-procedure (SubPro) which will use the data at A1:A4
4. Then copy D1:D4 to A1:A4 and run SubPro again until no more data to copy. In this case the data end at G1:G4, but it varies case by case.
5. The macro stops at A1.

Thanks

[nilem]

maybe something like this

Please Login or Register  to view this content.

[kent97]

Yes!

Thank you nilem