Greetings,
I'm new to using VBA and need some help. I need to be able to access cell data in a form that allows me to change the cells being used in a loop so that I can count through them.
At present the only way I know how to access cell data is through the Range command:
e.g. Var1 = Range("`sheet`!DA6").Value
In addition I need to be able to have the starting reference of the formula change with the active cell in the worksheet. So ideally what I want is something like:
Var1 = ActiveCell("`sheet`!R[n]C[y]")
Where I can set the values of n and y and change them in a For-Next loop. Unfortunately the above structure doesn't work. Can anyone help? I appologise if my explaination is not very clear.
Regards,
Gerald Chappell
I'm new to using VBA and need some help. I need to be able to access cell data in a form that allows me to change the cells being used in a loop so that I can count through them.
At present the only way I know how to access cell data is through the Range command:
e.g. Var1 = Range("`sheet`!DA6").Value
In addition I need to be able to have the starting reference of the formula change with the active cell in the worksheet. So ideally what I want is something like:
Var1 = ActiveCell("`sheet`!R[n]C[y]")
Where I can set the values of n and y and change them in a For-Next loop. Unfortunately the above structure doesn't work. Can anyone help? I appologise if my explaination is not very clear.
Regards,
Gerald Chappell