I'm not following your question. Your macro does what (I understand) you
are asking for.

"arlen andrews" wrote:

I need to automate a macro to use calculated cell addresses in the macro (see
present macro)

Sub Macro4()
CELL = "AZ54"
RANGE (CELL).select
End Sub

How can I insert a calculated Cell Address for the AZ54 in the above macro?