Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting name of sheet
Hi all
I would like to get the name of the sheet in cell A1, is there a function for that? Can I get it like this? Function GetPageName() GetPageName = Worksheets(5).Name End Function and use it in a cell like =GetPageName( WhatDoI_needToPutHere? ) When printing, I want all pages to be landscape - how do I do that? And the 2 upper lines, should read: <page name pageno. < of pages Headers.... WBR Sonnich |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel sheet bootom half sheet goes behind top part of sheet | Excel Worksheet Functions | |||
Duplicate sheet, autonumber sheet, record data on another sheet | Excel Worksheet Functions | |||
Copying cells from on sheet to another sheet (via sheet module) | Excel Programming | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |