| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Resize Range - Macro
Hi,
Please write a macro to CHANGE number of rows 3 to a variable range (end.xlDown) on the macro below. Sub GotToRangeResizeCopyPaste() Application.Goto Reference:="MyRange" ActiveCell.Resize(3, 10).Select Selection.Copy Range("OtherRange").Select ActiveSheet.Paste End Sub Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Range Name in Macro | Excel Worksheet Functions | |||
| Macro to copy range from Excel files in folder | Excel Discussion (Misc queries) | |||
| Is it possible to set a variable range in a macro? | About this forum | |||
| Macro - define cell range for a sum function | Excel Discussion (Misc queries) | |||
| Help with macro formula and variable | Excel Worksheet Functions | |||
Threaded Mode
