* Andrew Douglas Pitonyak <[EMAIL PROTECTED]> [010605, 00:54]:
> The macro is from a chapter that I am considering placing a new book,
> but I might just release it as is... Have not decided if I have time to
> finish another book.
Hi Andrew,
I would like to thank you again for your assistance: just in case
you didn't see my subsequent posts I would like to make it clear that
I have got allright my first half of the job (create named range with a
macro) and no doubt I'd never had accomplished that without your
suggestions: it were some of the rows in your Listing 6.9 (where you
also explain the base 10 to base 26 number conversion to get the correct
column letter) which opened my mind :-) [BTW, looking back at my answer
to Paolo Mantovani message, I see there is an unwanted final parenthesis
(after the esclamation mark '!') which might slightly false the meaning
of my phrasing ... Sorry for that :-)
Back to my problem: I fear there might be a bug preventing the macro to
delete a named range; I've modified the if condition so that, in case
the named range already exists it should delete it and then (after the
end if) create the new one. However it does not create the new
'last_bal' because it seems unable to delete the old one.
To make things a bit clearer I sent a new post ('Range name deletion
within a macro'). Would you mind giving a look and possibly an
indication of where I'm wrong?
Thanks again,
Ennio.
>
> Ennio-Sr wrote:
>
> >Hi Andrew,
> >thanks for your quick reply.
> >I tried a few of your suggestions this night without getting any result;
> >but they do work now (may be I was too tired ;) )
> >
> >>[skip]
> >>
> >>*REM I could obtain the cell address by obtaining the cell*
> >>
> >>*REM and then extracting the address from the cell.*
> >>
> >>
> >
> >This is exactly what I need.
> >How can I extract the cell address after the cursor has been positioned
> >onto
> >a cell?
> > [skip]
> >>--
> >>Andrew Pitonyak
> >>My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
> >>My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
> >>Free Info: http://www.pitonyak.org/oo.php
> >>
> >>
> >
> >Thanks,
> > Ennio.
> >
--
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo. \\?//
Fa' qualche cosa di cui non sei capace!" (diceva Henry Miller) ] (�|�)
[Why use Win$ozz (I say) if ... "even a fool can do that. )=(
Do something you aren't good at!" (as Henry Miller used to say) ]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
