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)
|