Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do l get the sheet name from the sheet code name?
I am sure this should be pretty simple but so far the answer has
eluded me. I am doing a project which involves retrieving data about the vbe. Thanks to Chip Pearson's excellent code examples so far it has gone fine. However l am having trouble retrieving the worksheet name that appears on the worksheet tabs. So using Chip's code l can retrieve the sheet code names, Sheet1, Sheet2 etc and list them as required. Lets say the the tab name that appears to the users is "A" for Sheet1 and "B" for Sheet2 So lets say that l now have Sheet1 in Cell(1,1) of a sheet called "MyModules". The question is how do l get the tab name ("A") as it appears to the users? Debug.Print Sheet1.Name returns "A" Debug.Print Sheets(Sheet1.Name).Name returns "A" but if you use code something along the lines of: Sub ReturnTabName Cells(1,1).Name or Sheets(Cells(1,1).Value).Name or Sheets("MyModules").cells(1,1).Name etc End Sub nothing is returned! All help gratefully appreciated Regards Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help to code Macro to Copy fron one sheet and paste in other sheet | Excel Programming | |||
Copying code behind from a sheet to a sheet in another workbook. | Excel Programming | |||
Programmatically determining CODE NAME for sheet based upon Sheet | Excel Programming | |||
excel - macro code to open a protected sheet, enter passowrd, and then protect sheet | Excel Programming | |||
unprotect sheet in code and make sheet visible | Excel Programming |