| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range
I am attempting to copy a range of cells in a macro. Each time the macro is
run the columns remain the same but the rows are different each time. I am able to move the active cell to column A of the wanted row but want to select cells from A through K in that row only to copy. Am a complete novice to Office programming. Help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting a range
Hi
maybe activecell.resize(1,11).copy -- Regards Frank Kabel Frankfurt, Germany Dean wrote: I am attempting to copy a range of cells in a macro. Each time the macro is run the columns remain the same but the rows are different each time. I am able to move the active cell to column A of the wanted row but want to select cells from A through K in that row only to copy. Am a complete novice to Office programming. Help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help with selecting a range | Excel Discussion (Misc queries) | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| Selecting a Range inside a range | Excel Programming | |||
| Selecting a range | Excel Programming | |||
| Help with selecting a range... | Excel Programming | |||
Linear Mode
