Create formalu that references sheet number (not sheet name)

[UHsoccer]

Is there a way in a formaula to reference a sheet by number as opposed to by name

 

[Joe4]

Re: Create formalu that references sheet number (not sheet n

In VBA, yes. But I don't think you can without it.

 

[PaddyD]

perhaps:

http://www.mrexcel.com/board2/viewtopic.php?t=74234

 

[Joe4]

Re: Create formalu that references sheet number (not sheet n

I stand corrected! It ain't pretty, but it sounds like it works. I would probably go the UDF route (which uses VBA), just because it looks cleaner and is more readable, but that's just me...

 

[UHsoccer]

Re: Create formalu that references sheet number (not sheet n

Thanks for the help, it works nicely using the myRef function