I have a macro that is designed to read thru all active sheets in a workbook (ignoring the hidden sheets) but i am getting stuck when i come to the 'last' sheet, the macro aborts on the command i am using to move from the 1st sheet to the last sheet - ActiveSheet.Next.Select. What technique can be used to know when you have reached the last sheet or is there a way to get a count of the number of active sheets and set up a loop to read the correct number of sheets? This macro is intended to work on a collection of workbooks in one folder.
Thanks in advance!!
Bookmarks