Adding the contents of a string variable as a named range

[ragtopcaddy via AccessMonster.com]

How do I implement the following where rngName is a string variable?:

WkBk.Names.Add Name:=rngName, RefersToR1C1:="=" & wkshtName & "!" &
ActiveCell.CurrentRegion.Address

As it is, I get the msg, "Run-Time Error '1004'" "The formula you typed
contains an error"

Thanks,

 

[ragtopcaddy via AccessMonster.com]

It turns out that the name wasn't causing the failure, it was the address of
the currentregion.

I will repost the question with a proper subject line, but for the time being,
the address must be R1C1, but the currentregion.address returns an A1 style
reference. I now have to find out how to convert A1 to R1C1.

Reposted here:

http://www.accessmonster.com/Uwe/Fo...ll-reference-to-xlR1C1-style#853b9ebcb3ac2uwe