I am trying to implement INDIRECT function in VBA, while using variables, but I am doing it wrong. Could anyone please tell me how the code should be written? In the following example I am trying to read the value from cell A1:
Dim xxx as Integer
xxx = 1
ActiveCell.FormulaR1C1 = "=INDIRECT(""A" & xxx")"
Thanks in advance!
Dim xxx as Integer
xxx = 1
ActiveCell.FormulaR1C1 = "=INDIRECT(""A" & xxx")"
Thanks in advance!