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.

VBA Macro to Clear Named Cell Contents
 

Try this, just drop this into VBA

Sub RemoveRange
Dim nm As Name

For Each nm In ActiveWorkbook.Names
Debug.Print nm.Name & " refers to " & nm.RefersTo
If InStr(1, nm.Name, "clr_") 0 Then
Range(nm.Name).ClearContents
End If
Next nm

End Sub

VBA Macro to Clear Named Cell Contents
 

Dim nme As Name

For Each nme In ActiveWorkbook.Names
If Left(nme.Name, 4) = "clr_" Then
Range(nme.Name).ClearContents
End If
Next nme


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

wrote in message
oups.com...
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.

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