grabbing cell reference

C

cparsons

I am running a macro where I look for certain values in cells. Based o
what I find I name that cell using

ActiveWorkbook.Names.Add Name:="RAF_QTR_" & RAF_Occur
RefersToR1C1:="=worksheet_name!R1C1"


My problem is I need to update R1C1 to reflect the active cell.

Any suggestions.

Thanks
 
F

Frank Kabel

Hi
try:
ActiveWorkbook.Names.Add Name:="RAF_QTR_" & RAF_Occur,
RefersToR1C1:="=" & activecell.address
 
Top