* Paolo Mantovani <[EMAIL PROTECTED]> [310505, 23:47]:
> Hi Ennio,
>
> Alle 19:19, marted� 31 maggio 2005, Ennio-Sr ha scritto:
> > Hi Andrew and other macro experts. I made some progress:
> > the macro I wrote is not very elegant but I feel I'm getting near the
> > final result: 'Print xcls$' now shows correctly the selected cell as
> > '$C$3'; the point is: Why the named range is not created?
> > Where is the error? Can you help?
> [...]
>
> I tried your code and the the named range has been regularly created
>
> ciao
> Paolo M
>
Thanks for your message, Paolo (and for the nice macro where I copied
from ;); very interesting the base 10 to base 26 number conversion to
get the correct column letter! ).
AAMOF, In the meantime I found out what was preventing the correct
creation of the range: there was already a range named 'last_bal'
although it referenced a null value.
Now I'm stucked at the way I can get rid of the range if it is already
there. In other words, if last_bal already exists (as normally would be
in a running account) it must first be deleted, otherwise the new one
will not be correctly set up and Calc (?, better Basic) will issue an
exception. I could not find an example of how to do that in spite of all
my readings ;( ...
Ciao,
Ennio.
---- out of record comment ---
Pero', lasciamelo dire: tutto sto @asino per quello che in Lotus 123 era
un semplice '/rnc' (range name create) ;-) .....
---- end ----
--
[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]
