Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Using this macro....
Sub Finale() Range("B2:B11").Select Application.Run "Move2help" Application.Run "Drop3" Application.Run "MoveTotal7" Application.Run "Clean" End Sub What I'm trying to get to work is after the Clean macro runs I want to Loop back to the beginning and instead of Range("B2:B11").Select I want to Select the same Row range but one column to the right, so Range("C2:C11").Select. Then I would like it to keep looping while incrementing up one Column each Loop but keeping the same row range (2:11). I would like the Loop to stop when it gets to a Column where there is no Data, So if there was data in L2:L11 but none in M2:M11 the Macro will quit when it hits M. TIA, Dennis =================== |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Please help with loop | Excel Discussion (Misc queries) | |||
Looping Macro to Find and Mark | New Users to Excel | |||
macro loop | Excel Discussion (Misc queries) | |||
How to incorporate Loop feature | Excel Discussion (Misc queries) | |||
VBA Newbie: Help with Do Loop code | Excel Discussion (Misc queries) |