Create formalu that references sheet number (not sheet name)

UHsoccer

Well-known Member
Joined
Apr 3, 2002
Messages
1,023
Is there a way in a formaula to reference a sheet by number as opposed to by name
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,843
Office Version
  1. 365
Platform
  1. Windows
Re: Create formalu that references sheet number (not sheet n

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

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,843
Office Version
  1. 365
Platform
  1. Windows
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

Well-known Member
Joined
Apr 3, 2002
Messages
1,023
Re: Create formalu that references sheet number (not sheet n

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

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,727
Members
410,630
Latest member
JFORTH97
Top