| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to copy down specific number of rows
Hi Tom,
Tom Ogilvy schrieb: Using Resize might be clearer in terms of intent. Just offered for consideration. Range("A2").Resize(Range("B1").Value ,1).Value = Range("A1").Value thus it goes naturally also :-) -- Mit freundlichen Grüssen Melanie Breden - Microsoft MVP für Excel - http://excel.codebooks.de (Das Excel-VBA Codebook) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy specific rows to different work sheets | New Users to Excel | |||
| Copy / paste only specific rows | Excel Discussion (Misc queries) | |||
| how can i automate the copy-insertion of a specific number of rows | Excel Worksheet Functions | |||
| INserting Specific Number of Rows via macro | Links and Linking in Excel | |||
| COPY AND PASTE SPECIFIC ROWS | Excel Discussion (Misc queries) | |||
Threaded Mode
