Thread: VBA Macro to Clear Named Cell Contents
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default VBA Macro to Clear Named Cell Contents
You have another reply in .misc.

wrote:

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.

--

Dave Peterson
Reply With QuoteReply With Quote