Hi
This does not appear to be a major problem, I am just wondering if something might be corrupt?
Also it is an interesting curiosity…. _..
_..So I have a file , ( which I have uploaded) , that as far as I know I have never added any Charts ( or any of the old type Macro sheet things , - those that are still kept for backward compatibility, ( Hit Ctrl+F11 when in an Excel Spreadsheet to get one of those ). )
The worksheet count gives the 4 Tabs that I see.
The Sheets count gives me 5
I ran this simple code:
In the first half of the code for the loop for the 4 Worksheets I get exactly the results I expect. – four Worksheets are found, and the names appear as written on the Tabs.Please Login or Register to view this content.
In the second half code section for the loop of Sheets, In the first loop , it does not appear to select anything, but gives me the name of my first code module “AlanPike”.
As far as I know that is a normal code module and not one of the old Macro modules: Module “AlanPike” is visible in the VB Editor as one of 10 modules. ( As far as I can remember I added them all in the same way)
( Usually the old Macro modules appear as a tab in the worksheet, (when you Hit Ctrl+F11 when in an Excel Spreadsheet ) . Such a macro module is not usually visible in the VB Editor. They appear in the Sheets count and not in the Worksheets count )
The file is not important , it was an old temporary file I was about to delete when I noticed by chance this strange phenomena, so thought I would investigate in case it revealed anything interesting. I think the file started out as a Personal macro File, which I then copied into a trash folder, where it is now, and I may have used it a few times for nothing important.
Anyone can spread any light on this weird phenomena?
Thanks
Alan
Bookmarks