Hello Guys,
I need modify this vba code to be able to past into the next specified range in the next blank row, instead of having to select the row to be pasted into every time
here is the code
Windows("mark.xlsx").Activate
Range("C5:G5").Select
Selection.COPY
Windows(sam.xlsb").Activate
sheets("2").select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
End sub
many thanks inn advance
Bookmarks