Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
offset copy
Have the following code do not fully understand the parts. It works but I am
trying to only copy & paste part of the data. Data is in columns 'A' thru 'H'. I wish to copy 'A' thru 'E'. Have hit a brain dead spot. If someone can define or set this code I think then I can get it. Set rngPaste = rngPaste.Offset(0, 0) Range(Target.Offset(0, -7), Target.Offset(0, -7)).Copy _ Destination:=rngPaste rngPaste.Offset(0, 7) = Target |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy offset rows | Excel Discussion (Misc queries) | |||
copy offset to cell | Excel Discussion (Misc queries) | |||
Find, Copy offset to offset on other sheet, Run-time 1004. | Excel Programming | |||
copy and paste with offset | Excel Discussion (Misc queries) | |||
Copy & Paste+Offset | Excel Programming |