| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Verify if sheet name still exist
I have many sheets in the workbook. The cells in Column A of Sheet1 contains
the sheet names of each worksheet in the workbook, which is filled in by myself manually, periodically. Because I sometimes delete some sheets without updating the records in Column A of Sheet1, I need a macro to distinguish if the names contained in Column A of Sheet1 is still valid ie. sheet name is still existing among the worksheets in the workbook. It will be good to return the result as a remark (€śpresent€ť or €śabsent€ť) in Column B of Sheet1. VBA rookie here. Thanks a lot -- Edmund (Using Excel XP) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| verify if spesific sheet exist | Excel Discussion (Misc queries) | |||
| Verify if a workbook exist with a macro | Excel Programming | |||
| Verify if Comment exist in a cell | Excel Discussion (Misc queries) | |||
| Does the sheet exist? | Excel Programming | |||
| Does sheet exist? | Excel Programming | |||
Threaded Mode
