Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
formula references two embedded excel objects in Word doc Jeff Excel Worksheet Functions 1 August 15th 08 02:08 AM
screen goes black when creating or dragging drawing objects ... Tori Dunbar Excel Discussion (Misc queries) 1 February 4th 08 04:19 PM
Unable to remove Sheet objects in the Microsoft Excel Objects Adrian[_7_] Excel Programming 1 August 26th 04 10:49 PM
Creating remote objects Erich Neuwirth Excel Programming 13 May 13th 04 11:53 PM
How to references objects that exist on local or network drives that aren't open. Mike-hime Excel Programming 0 January 7th 04 10:15 PM


All times are GMT +1. The time now is 10:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"