Change a Function
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
|