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
|