use of indirect function in vba
 

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

use of indirect function in vba
 

Hi,

Try:

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

Hoop this helps,


Executor

use of indirect function in vba
 

thank you. that helps.


"Executor" wrote in message
oups.com...
Hi,

Try:

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

Hoop this helps,


Executor