View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chuck Taylor Chuck Taylor is offline
external usenet poster
 
Posts: 8
Default "Sheet" versus "Worksheet"

When I need to switch from one worksheet to the other, I usually use
code like:

Worksheets("Sheet1").Select (or Activate)

But sometimes this just doesn't work unless I change it to:

Sheets("Sheet1").Select

Just for the sake of curosity, what's the difference between "Sheets"
and "Worksheets"? Excel help file isn't much help.

J