use of indirect function in vba

[R..VENKATARAMAN]

indirect function is not one of the worksheet functions available in vba.
but
the code
Range("E8").Select

ActiveCell.FormulaR1C1 = "=INDIRECT(R[-7]C[-4])"
Range("E8").Select
(this is based on a macro created on going through the steps)
works . But

activecell=indirect(range("a1")) does not work
nor
activecell=application.indirect(range("a1"))
nor
activecell.formula="application.indirect(range("a1")"

any comments or any of my codes wrong. ??

 

[Executor]

Hi,

Try:

Sub myIndirect()
Range("E8").Select
ActiveCell.Value = Range(Range("A1").Value).Value
End Sub

Hoop this helps,


Executor

 

[R..VENKATARAMAN]

thank you. that helps.