Inserting worksheet name as a variable into a function

[cadas]

Hi, can anyone help?

I am trying to use a macro to make a simple index page. If I was doing this in a worksheet I would input

=sheet1!a1

to take the contents of a1 on sheet 1 and put them into the cell on the index page.

However, I need to put this formula in where 'sheet1' is a variable defined elsewhere in the macro. I can easily put the value of the cell in, but as the contents change, I want the cells to update, therefoe I need the formula

I have been trying variations on

activecell = "=(var1)!a1"

' where var1 is the variable of the worksheet name, but it treats var1 as text and not a variable.

Any help appreciated.

[ravishankar]

Hi
try "=" & Var1 & "!A1"
Ravi

[DonkeyOte]

Perhaps you mean

Please Login or Register  to view this content.

[cadas]

Thanks, I guessed it was something simple.