Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Jentan,
Try: '============= Public Sub Tester() Dim srcRng As Range Dim destRng As Range Set srcRng = Range("A1:E1") Set destRng = Range("A2") srcRng.Copy Destination:=destRng End Sub '<<============= To find appropriate syntax, try turning on the macto recorder while you perform the operation.manually. Whilst recorder code is rarely optimised code, it will provide you with a syntactical solution, --- Regards, Norman "Jentan" wrote in message oups.com... Anyone out there can teach me how to copy a range(say row A1 - E1) to row A2-E2 using the range command. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
RANGE EXCEL copy cell that meets criteria in a range | Excel Worksheet Functions | |||
copy formulas from a contiguous range to a safe place and copy them back later | Excel Programming | |||
Create/copy combo boxes in one range if condition is met in a different range | Excel Programming | |||
Code to copy range vs Copy Entire Worksheet - can't figure it out | Excel Programming | |||
Range COPY function - how to copy VALUES and not formulas | Excel Programming |