| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rename a range of cells with a macro
If someone is able to help, I need a macro that will select a given range of
cells then convert them to a new name: See example If C7:C20 is = 0.1 then replace cell contents with 625 Basically, I need to replace the contents of all cells in a given range (that contain data) with a constant number like 625. If the cell is blank I want to leave it blank. -- Jake |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rename a range . | Excel Discussion (Misc queries) | |||
| Copy, Paste and Rename a Range using a macro | Excel Discussion (Misc queries) | |||
| Rename Several Defined Range Names with Macro | Excel Programming | |||
| rename cells with a macro | Excel Programming | |||
| Rename a Range, programatically? | Excel Programming | |||
Threaded Mode
