Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Help With Creating A Loop
Below is a macro I am using. I need help with creating a loop once the macro is ran it will move down to the next row and continue until it reaches down to the row that is empty. This is the very first section that my macro runs. I have to manually select the first row which is B2:BG2. I want to be able to hit the button and it automatically select B2:BG2 run all the way through the macro then start over again but move down to C2:CG2 and so on. Also, I would like the loop to stop once it reaches the last row that has data in it or stop as soon as it reaches the first row that is empty. If any one could help I would appreciate it. Thank You in advance. Sub BAGAFEDEXEXPEDITES() Application.ScreenUpdating = False Set RangeName = Selection Selection.Copy Workbooks.Open ("L:\BAGA\02 PACKING SLIP TEMPLATES\BAGA BLANK FEDEX.xls") Windows("BAGA BLANK FEDEX.xls").Activate Range("H15").Activate Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Run "BAGAFEDPLTFRM" End Sub Thank You, Zero -- zero635 ------------------------------------------------------------------------ zero635's Profile: http://www.excelforum.com/member.php...o&userid=24802 View this thread: http://www.excelforum.com/showthread...hreadid=480185 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with creating a loop | Setting up and Configuration of Excel | |||
creating a loop | Excel Discussion (Misc queries) | |||
Creating a loop | Excel Discussion (Misc queries) | |||
Creating a loop | Excel Programming | |||
Creating a For Loop | Excel Programming |