Cell reference

[AM]

Hi everyone!

It's possible to do something like this in a cell:

=Sheet" & Range("A1") & "!A1

Thanks a lot.

AM

 

[AM]

Hi everyone!

It's possible to do something like this in a cell?

=Sheet" & Range("A1") & "!B2

The goal is to select the cell A1 in the Sheet1 if Range("A1") =1.

Thanks a lot.

AM

 

[brettdj]

If you were in say Sheet2, and cell B2 (to make the example clearer) in Sheet2 contained 1 then
=INDIRECT("Sheet1!A"&B2)

will return the value of A1 from Sheet1

Cheers

Dave

 

[Jonmo1]

Try

=INDIRECT("Sheet" & A1 & "'!A1")

 

[brettdj]

Try
=INDIRECT("Sheet" & A1 & "'!A1")

Yes - on rereading I think I misinterpreted that the sheet name, not row was the variable

Cheers

Dave

 

[AM]

Hi

Thanks for replying to my question.

I've only had to change a little bit your sugestion deleting the ' that's before the !

=INDIRECT("Sheet" & A1 & "!A1")

Thanks again

AM