grabbing cell reference

  • Thread starter Thread starter cparsons
  • Start date Start date
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
 
Hi
try:
ActiveWorkbook.Names.Add Name:="RAF_QTR_" & RAF_Occur,
RefersToR1C1:="=" & activecell.address
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel List Box Help 1
VBA function to define name in a worksheet 2
Named range with multiple groups of cells 4
select a range in a macro 3
Two Questions: R1C1 and stop text number converting to data 5
Naming a cell from VB 3
Curious string error in named range automation attempt - just doesn'tseem to make sense! 5
Excel List Box 5

Back
Top