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. ??