P
Peter
i have this line which copies and pastes in the one statement:
Sheets("AUS-SA_AgeGrp4M").Range("a1:aq" & LRow).Copy
Destination:=Sheets("Sheet2").Cells(1, LCol + 1)
could someone pls suggest what the code would look like to make it paste as
paste special?
Sheets("AUS-SA_AgeGrp4M").Range("a1:aq" & LRow).Copy
Destination:=Sheets("Sheet2").Cells(1, LCol + 1)
could someone pls suggest what the code would look like to make it paste as
paste special?