Re: how does excel decide a suggested name to a range?

Tech-Archive recommends: Speed Up your PC by fixing your registry


Thanks for your help Steve. I have posted the workbook to you
regards

Iain

STEVE BELL Wrote:
> If you would like - send it to my email and I'll have a look...
>
> rand451@xxxxxxxxxxx
>
> --
> steveB
>
> Remove "AYN" from email to respond
> "iainshaw" <iainshaw.1tigqr_1123614396.5294@xxxxxxxxxxxxxxxxxxxxx>
> wrote in
> message news:iainshaw.1tigqr_1123614396.5294@xxxxxxxxxxxxxxxxxxxxxxxx
> >
> > Ok, thanks again Steve
> >
> > but I can no longer get this to work. By that I mean if I try to
> run
> > it in a *** where there are c. 15 range names defined it does not
> > appear to do anything. I have another routine that cycles through
> the
> > *** naming dynamic ranges pulled out of a dB. What I'd like to be
> > able to do is to clean down the rangenames whenever I add to the dB.
> >
> > So - the code in the Workbook is as follows:
> >
> > Sub CleanDown()
> >
> > Dim RName As Name
> >
> > For Each RName In Active***.Names
> > RName.Delete
> > Next RName
> >
> > End Sub
> >
> > I can run the code in the workbook and the c.15 Range Names that
> are
> > there remain unaffected. Is there any other information I need to
> > provide to debug this. As I say it worked fine yesterday. It
> doesn't
> > work today even though I have added your Dim statement to it. The
> code
> > looks fine to me
> >
> > There are no error messages generated
> >
> >
> > --
> > iainshaw
> >
> ------------------------------------------------------------------------
> > iainshaw's Profile:
> > http://www.excelforum.com/member.php?action=getinfo&userid=25748
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=360224
> >


--
iainshaw
------------------------------------------------------------------------
iainshaw's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25748
View this thread: http://www.excelforum.com/showthread.php?threadid=360224

.

Quantcast