indirect formula vba error

[oldmanwilly]

HI

Why do i get an error on this formula?

Cells(3, i).Formula = "=INDIRECT('Data 2 (2)'! & ADDRESS($A3,J$1))"

Thanks

 

[AlphaFrog]

The formula requires quotes around "'Data 2 (2)'!"

Within a VBA string, one literal quote is represented by two consecutive quotes.

Cells(3, i).Formula = "=INDIRECT([COLOR=#FF0000]""[/COLOR]'Data 2 (2)'![COLOR=#FF0000]""[/COLOR] & ADDRESS($A3,J$1))"

 

[Jonmo1]

Try

Cells(3, i).Formula = "=INDIRECT(""'Data 2 (2)'!""&ADDRESS($A3,J$1))"

 

[oldmanwilly]

both good, thanks guys