Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Column in R1C convention
I know I want to copy column N on a specific worksheet name where N is
variable and is a number (column 2, 5, 8, whatever). How do I write the code to copy that column? Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Column in R1C convention
assuming you want to copy the entire column from the activeworksheet
n = 3 Columns(n).Copy or n = 3 Sheets("Sheet2").Columns(n).Copy if it is not the active sheet or you could add workbooks("bookname") if it is in another workbook hope this helps David "Barb Reinhardt" wrote: I know I want to copy column N on a specific worksheet name where N is variable and is a number (column 2, 5, 8, whatever). How do I write the code to copy that column? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Variable Naming Convention | Excel Programming | |||
Anyway to set numerical column name as Exel convention? | Excel Worksheet Functions | |||
Formatting convention for code | Excel Programming | |||
Naming convention for a variable "Book1" while copying sheets | Excel Programming | |||
Error 49: Bad .dll Calling Convention | Excel Programming |