On Thursday, June 14, 2012 1:06:18 PM UTC+8, GS wrote:
Did you even try my suggestions? It uses 'fully qualified' refs and so
should not raise an error!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


@Garry : Thanks for the suggestions, and I did try it out, but it's no joy. It's still giving the same error.
What I meant earlier was that it appears as if the Worksheets / Sheets collection isn't working in the first place. The problem definitely isn't with anyone modifying the contents of the file, as I'm the only one who has access to it. My own opinion is that some reference to the functions or properties under the Worksheets / Sheets is now missing or deleted in some way.

To explain it further, I can't even access any sheets using the sheet index numbers. Even the following line causes the same error
Worksheets(1).Activate
or
Sheets(1).Activate

for any index number.