View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jack_Feeman Jack_Feeman is offline
external usenet poster
 
Posts: 47
Default What is the difference beyween "Sheets" and WorkSheets" in subrout

I have modules that refer to worksheets sometimes as Sheets("sheetname") and
sometimes as Worksheets("sheetname").

Even when they are used in the same routine, I get no error message and the
routine works (at least on my machine; the one it was composed on. Others
reporting that it is erroring out for them.)

Where does Excel do its versioning? I thought since some of the errors
indicate it routine is calling the macro from an old version of the document
that it may be a versioning issue (although none of my modules shows a past
version in the code).

Thanks
Jack