View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MDW MDW is offline
external usenet poster
 
Posts: 117
Default 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!