cell("Address") problem

name Address_R refers to $A$30

name Blank_R refers to $C$8



cell Address_R formula : =cell("Address",Blank_R)

cell Address_R display : $C$8



When I click a button with an assigned macro, before the macro even executes the first line,

cell Address_R display changes to "R8C3".



I've simplified the code

dim sRange as string, rCell as range

sRange = "R"

'next line crashes

set rCell = range(range("Address_" & sRange).value)

If I stop the code, go to Address_R, put my cursor in the formula bar and hit "Enter" (i.e. i don't change the contents of the cell) then the display changes back to "$C$8" and then macro continues fine.