| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to select a range whose name is entered in a cell.
I have four ranges named A, B, C, D.
I need to be able to copy (and paste) one of them when its name is entered in a cell. What is the macro syntax to get the value in a cell and use it to select a range, please? I would attach this macro to a button (which I know how to do) to allow the user to enter the range name and click the button to copy it to a fixed location (that I know how to specify) Thanks!. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
| How to Select a relative range with Using "Find" and Offset() | Excel Discussion (Misc queries) | |||
| I cannot select a range | Excel Discussion (Misc queries) | |||
| Select a range | Excel Discussion (Misc queries) | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Threaded Mode
