knowledge.
Regards - Dave.
Date: Tue, 15 Feb 2011 05:00:59 -0800
From: schreiner_p...@att.net
Subject: Re: $$Excel-Macros$$ A little OT
To: excel-macros@googlegroups.com
The biggest confusion here is the difference between
the Worksheet OBJECT: Sheet1
the Worksheet NAME: Sheet1
and Sh
kbook.
In answer to your question.. Your question contains syntax errors.
Because when you say there are 7 sheets, but Sheet(7) doesn't exist.
You mean that Sheet7 doesn't exist... Sheets(7) is the 7th element of the Sheets
ARRAY, which DOES exist.
Does that help? or was it so "wo
Hi Paul,
I have also noticed that after deleting and creating sheets, the Sheet numbers
are out of order, and can be missing altogether. ie in a workbook of 7 sheets,
one of them may be Sheet(11), while sheets 8 and 9 are not present at all.
So, my question is, why does this line of code (Sheets
