| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Macro to Clear Named Cell Contents
I have a workbook with approx. 30 named cells. They all start with
"clr_". I'm looking for some script that would look for all named cells beginning with "clr_" and then go through to delete the content of that named cell. for example "clr_projectname" would have the words "my project name" and i would like the script to go through and delete the words "my project name" from the cell and then go through looking for the next name beginning with "clr_" and delete the contents of that cell. HELPPPPPP PLZ. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to clear contents of certain cells | Excel Discussion (Misc queries) | |||
| Macro to clear contents and put an X | Excel Discussion (Misc queries) | |||
| VBA Excel Macro to delete contents in named cell | Excel Discussion (Misc queries) | |||
| Clear Contents Macro | Excel Worksheet Functions | |||
| MACRO TO CLEAR CELL CONTENTS | Excel Programming | |||
Threaded Mode
