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 ;) )
* Andrew Douglas Pitonyak <[EMAIL PROTECTED]> [280505, 18:56]:
>
>
> Ennio-Sr wrote:
>
> >Hi all,
> >I'm wondering whether it is possible to delete/create named ranges
> >by a macro.
> > [skip]
> >
> Is this enough to get you started?
>
Perhaps too much :-)
>
> In a macro, a named range is accessed, created, and deleted using the
> NamedRanges property of a Calc document. Use the methods hasByName(name)
> and getByName(name) to verify and retrieve a named range. The method
>
> [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?
> [...]
The following do not seem to be strictly necessary (or am I loosing some big
point?)
>
> *REM com.sun.star.sheet.NamedRangeFlag.FILTER_CRITERIA = 1*
>
> *REM com.sun.star.sheet.NamedRangeFlag.PRINT_AREA = 2*
>
> *REM com.sun.star.sheet.NamedRangeFlag.COLUMN_HEADER = 4*
>
> *REM com.sun.star.sheet.NamedRangeFlag.ROW_HEADER = 8*
>
> *oRanges.addNewByName(sName$, "$Sheet1.$B$3:$D$6", oCellAddress, 0)*
^^^^^^^^^
The pointer is already on a cell (variable position: last row of the
file): what shall I put here?
> *End If*
>
> *oRange = ThisComponent.NamedRanges.getByName(sName$)*
>
> *REM Print the string contained in cell $Sheet1.$B$3*
>
> *Print oRange.getReferredCells().getCellByPosition(0,0).getString()*
I skipped this as well and seems to work.
>
> *End Sub*
>
> The method addNewByname() accepts four arguments; the name, content,
> position, and type. The fourth argument to the method addNewByName() is
> a combination of flags that specify how the named range will be used
> (see Table 2)?the most common value is 0.
>
> --
> 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]
