| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Copy Active Cell to Range Name, loop
ActiveCell.Resize(3,1).name = ActiveCell.Value
-- Regards, Tom Ogilvy wrote in message ups.com... Thanks, but actually trying to capture the entire range of say, Active cell of b10 to B13 (B10:B13), then move to the name field and type only the data copied from the initial active cell. This would create a named range, with the name being whatever is in the first cell ... in this case, b10. Thanks!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy name from active sheet to cell - using macro or function | Excel Worksheet Functions | |||
| need to Copy or Move to active cell from specified range | Excel Discussion (Misc queries) | |||
| Macro to copy cell data to word document based on an active row? | Excel Programming | |||
| declaring active cell inside a for loop and offsetting from it | Excel Programming | |||
| How? Macro to copy range to new worksheet, name new worksheet, loop | Excel Programming | |||
Threaded Mode
