View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Refer to Previous or Next Sheet

See

http://www.mcgimpsey.com/excel/udfs/prevsheet.html

In article ,
"build" wrote:

G'day All,
Is it possible to refer to a cell on the previous sheet IN A FUNCTION
without refering to the sheet name?
Do sheets have index number or similar?

Thanking you in anticipation,
build