View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
excelent excelent is offline
external usenet poster
 
Posts: 695
Default 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