View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Whats the difference

Worksheets are a specific type of sheet, that are used for capturing and
manipulating data using functions and formulas. Sheets includes Worksheets,
Chart Sheets, Dialog sheets, macro sheets, etc.

--

HTH

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


"Pete" wrote in message
...
Whats the difference between using

Sheets

or

Worksheets

Example


Sheets("Sheet1").Range("D2").Copy

and


WorkSheets("Sheets1").Range("D2").Copy

They both seem to do the same thing. So is there any difference in using
them?