Edmund

You could try here for code which will rebuild your index for you and
provide hyperlinks and the sheet type

http://www.nickhodge.co.uk/vba/codeexamples.htm

At the bottom of page

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Edmund" wrote in message
...
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)