Creating References To Excel Objects
This may be purely user preference, but not sure.
If I want to refer to an Excel sheet, either of the following formats works
for me:
With objWorkbook.Worksheets("MY SHEET")
.Range("A:A").Select
' Etc.
End With
OR
Set objSheet = objWorkbook.Worksheets("MY SHEET")
With objSheet
.Range("A:A").Select
' Etc.
End With
Any difference (performance, resource use, etc) between the two? Assume that
I have control over sheet names and they will remain constant.
--
Hmm...they have the Internet on COMPUTERS now!
|