Range name - how did this get in there
Posted by Brain Dead on June 01, 2001 1:09 PM
Hi:
Hope someone out there can provide a clue as to what this
is:
I was using ASAP addin & pulled all of my ranges
One range was named aaaa and was defined as :
={#N/A,#N/A,TRUE,"test";#N/A,#N/A,TRUE,"testC";
#N/A,#N/A,TRUE,"testCE";#N/A,#N/A,TRUE,"testCF";
#N/A,#N/A,TRUE,"testCM";#N/A,#N/A,TRUE,"testCMM";
#N/A,#N/A,TRUE,"testCMMM";#N/A,#N/A,TRUE,"testCMMP";
#N/A,#N/A,TRUE,"testCMMU";#N/A,#N/A,TRUE,"testCMN";
#N/A,#N/A,TRUE,"testCO";#N/A,
I recognize as an old range name that I thought I had
deleted. Some of the tabs listed above have even been
deleted.
As always, any suggestions or tips are greatly appreciated
Dead
Posted by Russell on June 01, 2001 1:35 PM
Re: Range name - what are you trying to do?
Do you want to delete that range? I'm not sure what you are trying to accomplish.
Posted by Brain Dead on June 01, 2001 2:05 PM
Re: Range name - what are you trying to do?
Russel:
Yes I would love to delete the name - however, I can't find it.
It's not a global level range name
* Can't see in Insert\Name\Define
* Doesn't show up Insert\Name\Paste
Doesn't look like a sheet level range name
that I've ever seen.
Thxs
Posted by Russell on June 01, 2001 3:58 PM
Re: Range name - what are you trying to do?
Try this:
Range("aaaa").delete
Posted by Brain Dead on June 01, 2001 5:37 PM
Re: Tried
Russel - Thxs for the tip, but (isn't there always one
hanging aroung) it doesn't seem to work. Tried 2
different ways.
A)
sub clear_me()
Dim sht As Worksheet
For Each sht In ActiveWorkbook.Sheets
sht.Select
On Error GoTo skip_me
Range("aaaa").Delete
skip_me:
Next sht
End Sub
B) - didn't think this would work
sub clear_me()
Range("aaaa").Delete
End Sub Try this: Range("aaaa").delete
Posted by Ivan F Moala on June 11, 2001 2:57 AM
Re: Tried
Try
ActiveWorkbook.Names("aaaa").Delete
Ivan
