I made this function, and it works ok

Function Ark(nr)
Ark = Sheets(nr).Name
End Function

Then i can type : =Ark(2) and get the sheetname.

But the problem is that i wana do this :
=Ark(2)!B3 to get the value in sheet(2) cell B3
but i cant make it work

haw do i change the function to make it work ?

thanks in advance

Any reason you don't want to use the indirect function something like this...

=Indirect(Ark(2) & "!B3")
--
HTH...

Jim Thomlinson


"excelent" wrote:

I made this function, and it works ok

Function Ark(nr)
Ark = Sheets(nr).Name
End Function

Then i can type : =Ark(2) and get the sheetname.

But the problem is that i wana do this :
=Ark(2)!B3 to get the value in sheet(2) cell B3
but i cant make it work

haw do i change the function to make it work ?

thanks in advance

Yep - ges the reason course my brain lag
Think i had tryed allmost anythin else than this :-)

thanks Jim geat job