Stop Copying at Specific Row
How do I stop copying, when the copy reaches B18:G18?
Here is the VBA that I use.
It copy's data from row B5:G5 to beginning line B8.
everytime the command copy button is pushed.
I want the copying to stop at row B18
then park the cursor everytime at A1
With Thanks
Steve
---------------------------------------------------------------------------------------
Sub CopyRange2()
Sheets("Sheet1").Range("B8").Select
'find your empty cell
Do Until ActiveCell.Formula = ""
ActiveCell.Offset(1, 0).Select
Loop
ActiveCell.Formula = Range("B5:G5").Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:=
_
False, Transpose:=False
Application.CutCopyMode = True
'Stop copying when the copying reaches B18:G18
Range("A1").Select
End Sub
------------------------------------------------------------------
|