SHEET Function To Check Sheets Environment In Excel
DEFINITION:- SHEET Function Returns The Sheet Number Of The Referenced Sheet Based On Its Position In The Workbook. It Can Return The Sheet Number Of Any Worksheet Including Visible, Hidden Or Very Hidden As Well As Macro, Chart And Dialog Sheets. Sheet Function Is Used To Get The Index Number For A Given Sheet Reference. The Index Are The Sequence Numeric Value Of A Sheets In An Excel Workbook, Start From Left As Index Number 1.
EXAMPLE 1 :- SHEET Function Returns The Sheet Number Of Active Sheet Based On Its Position In The Workbook. When No Arguments Are Provided The Sheet Function Returns The Index Number Of The Current Sheet.
EXAMPLE 2 :- When The Reference Is Provided The Sheet Function Returns The Sheet Number Of The Referenced Sheet Based On Its Position In...