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