Or even:

activecell.name = "USAR"



"yippy <" wrote:

Hi all,

I have a macro that i want to edit. At the end of my current macro,
the cursor is pointed to a specific cell, but it varies in location
everytime. What I would like to do is to add a line to my currrent
macro and name the active cell that it's pointing to. I have something
like ActiveWorkbook.Names.Add Name:="USAR",
RefersToR1C1:="=AR10!R175C14" currently, but the problem is, this
syntax has a specific reference to the cell location. I want to name
the active cell w/o referencing it's location.

Any help will be greatly appreciated!

Thanks,
Yippy

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson