Thanks All.

I'll try your suggestions

Bill

Rick Rothstein (MVP - VB) wrote:
You can get the R1C1 style address directly via the Address property's
optional arguments. For example, using ActiveCell for the Range object for
this example (use your own Range in place of it)...

Debug.Print ActiveCell.CurrentRegion.Address(ReferenceStyle:=x lR1C1)

Check out the help files for Address to see what other optional arguments
are available.

Rick

I need this function because in spite of successfully setting the reference
to xlR1C1 in code, the currentregion.address returns in A1 style.
[quoted text clipped - 8 lines]

Thanks,

--
Bill Reed

"If you can't laugh at yourself, laugh at somebody else"

Message posted via http://www.officekb.com