Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to copy several columns to a new worksheet. I have the following
code that does not copy the entire column correctly. It seems to copy only cells C1 to C4. There are empty spaces in this column. I would like for this to copy beginning at Org_Addr (this can be a variable location) and all the way down to the last row of data in this column. I appreciate the help! ALATL With SourceSheet .Range(.Range(Org_Addr), .Range(Org_Addr).End(xlDown)).Copy End With DestSheet.[C65536].End(xlUp)(1).PasteSpecial Paste:=xlValues |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA Copy Paste Issue | Excel Discussion (Misc queries) | |||
A macro to copy & paste many rows (a range) to the next column .. | New Users to Excel | |||
Copy & Paste Issue | Excel Discussion (Misc queries) | |||
Copy Paste issue | Excel Worksheet Functions | |||
Issue with copy & paste? | Excel Discussion (Misc queries) |