| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Macro copy range of cells
I need a macro to copy from the active cell over 11 columns and down 5500
rows. I need this copied to clipboard so I can paste in in new workbook Thanks in Advance for helping. Duane Reynolds |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Macro copy range of cells
How about
activecell.offset(5500,11).copy -- Don Guillett Microsoft MVP Excel SalesAid Software "Duane Reynolds 322310" wrote in message ... I need a macro to copy from the active cell over 11 columns and down 5500 rows. I need this copied to clipboard so I can paste in in new workbook Thanks in Advance for helping. Duane Reynolds |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Macro copy range of cells
Thsnks
I knew there hade to be a simple command "Don Guillett" wrote in message ... How about activecell.offset(5500,11).copy -- Don Guillett Microsoft MVP Excel SalesAid Software "Duane Reynolds 322310" wrote in message ... I need a macro to copy from the active cell over 11 columns and down 5500 rows. I need this copied to clipboard so I can paste in in new workbook Thanks in Advance for helping. Duane Reynolds |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Macro copy range of cells
I guess I did not give a very good description of what i needed. Don your
solution works great to copy that one cell, what I should have said is I need to copy the range of cells from the active cell to the cell 11over and 5500 down. Thanks Duane "Don Guillett" wrote in message ... How about activecell.offset(5500,11).copy -- Don Guillett Microsoft MVP Excel SalesAid Software "Duane Reynolds 322310" wrote in message ... I need a macro to copy from the active cell over 11 columns and down 5500 rows. I need this copied to clipboard so I can paste in in new workbook Thanks in Advance for helping. Duane Reynolds |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Need Macro copy range of cells
Thanks That one did just what I needed,
one question off topic, what book would you recommend that covers how all these "objects?" work and a description of how to use them. I was tring to select a range , copy etc was uing 6 or 8 lines for something that can be done with 3 or 4 words of the right code language. Thanks Duane "Don Guillett" wrote in message ... ActiveCell.Resize(5500, 11).Copy -- Don Guillett Microsoft MVP Excel SalesAid Software "Duane" wrote in message ... I guess I did not give a very good description of what i needed. Don your solution works great to copy that one cell, what I should have said is I need to copy the range of cells from the active cell to the cell 11over and 5500 down. Thanks Duane "Don Guillett" wrote in message ... How about activecell.offset(5500,11).copy -- Don Guillett Microsoft MVP Excel SalesAid Software "Duane Reynolds 322310" wrote in message ... I need a macro to copy from the active cell over 11 columns and down 5500 rows. I need this copied to clipboard so I can paste in in new workbook Thanks in Advance for helping. Duane Reynolds |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to copy range of cells and paste into 1 sheet | Excel Programming | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Use macro to check a range of cells within a row and copy wanted data to new sheet | Excel Programming | |||
| Use macro to check a range of cells within a row and copy wanted data to new sheet | Excel Programming | |||
| Use macro to check a range of cells within a row and copy wanted data to new sheet | Excel Programming | |||
Linear Mode
