Hi,

I'm new to VBA. Could anybody tell me what is the different between
sheets and worksheets object(?). I wonder when my program didn't work
and when I swift between that two, it became works.

I don't have any code with me now but I think it always happen when I
use to loop like this:

for each ws in Activebook.sheets (or worksheets)

Thanks in advance.
hideki


--
hideki
------------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903
View this thread: http://www.excelforum.com/showthread...hreadid=395348

Sheets refers to all sheet types, worksheets, charts, macro sheets, etc.
Worksheets is a specific type of sheet.

If ws was declared as type worksheet, and you have another type of sheet,
you will get a type mismatch error.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"hideki" wrote in
message ...

Hi,

I'm new to VBA. Could anybody tell me what is the different between
sheets and worksheets object(?). I wonder when my program didn't work
and when I swift between that two, it became works.

I don't have any code with me now but I think it always happen when I
use to loop like this:

for each ws in Activebook.sheets (or worksheets)

Thanks in advance.
hideki


--
hideki
------------------------------------------------------------------------
hideki's Profile:
http://www.excelforum.com/member.php...o&userid=18903
View this thread: http://www.excelforum.com/showthread...hreadid=395348

Sheets refer to worksheets, charts, etc. Worksheets only refers t
worksheets

--
cnaqui
-----------------------------------------------------------------------
cnaquin's Profile: http://www.excelforum.com/member.php...fo&userid=2624
View this thread: http://www.excelforum.com/showthread.php?threadid=39534