Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy nonadjacent range and paste
The macro aims to select whatever in column A and whatever in column C, then
copy and paste to a new workbook as column A and B. Since the number of rows in column A and C are uncertain, I have to use End Down to select the cells. However, the marco below only copy and paste column A but not C. What's wrong? Range("A1").Select Range(Selection, Selection.End(xlDown)).Select Range("A1:A5,C1").Select Range("C1").Activate Range(Selection, Selection.End(xlDown)).Select Selection.Copy Workbooks.Add ActiveSheet.Paste |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy, Paste and Rename a Range using a macro | Excel Discussion (Misc queries) | |||
Macro - copy a range and paste it in a new sheet 12 times | Excel Worksheet Functions | |||
macro to copy/paste range for printing | Excel Programming | |||
Macro to copy, paste in a range and then delete | Excel Discussion (Misc queries) | |||
Macro to copy range of cells and paste into 1 sheet | Excel Programming |