but it should be ..nah MUST be .. doable with

evaluate() and some string manipulation involving {}...
I'm sure!

problem is with name objects that some remnants
(hidden namespace) stay in memory...
and may lead to problems.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Peter T" wrote:

AhHa, thanks

Seems already elegant to me <g

Peter


-----Original Message-----
i use:
Sub ff()
With ActiveWorkbook
.Names.Add "tmp", "=Documents(3)"
v = [tmp]
.Names("tmp").Delete
End With
End Sub

keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Peter T" wrote:

Hi KeepItCool
<snip