Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? -- Peter |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run Time Error 2147417848 - 80010108 method Copy of Object Range F | Excel Programming | |||
copy method of object failing | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Union method for Range Object | Excel Programming | |||
Problem is using any method of Range Object | Excel Programming |