Write Indirect Function in VBA

[Richard Flame]

Hello,

I'm struggling a lot with the vba syntax for this function:
'=(INDIRECT(A1&"!D10"))

.Formula = "=(INDIRECT(A" & j & "" & "" & "!" & "D10))"
where j = 1

I can't get to properly write the &"!D10")) part of the function.

Please advise
Thanks

[royUK]

What are you doing? Are you trying to write the formula to a cell?

[shg]

Try this:

Please Login or Register  to view this content.