Inserting worksheet calculations into macros
Depends how you are calculating the address.
DIM strAddress as string
strAddress = "AZ"&54
if cell A1 on the active sheet contained an address like AZ54, you can do:
Range(range("A1").value).Select
BTW, you rarely need to SELECT a range. Most things can be done simply by
referencing the range. For example:
range("AZ54").formula = "=A1+c1"
"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?
|