Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula references two embedded excel objects in Word doc | Excel Worksheet Functions | |||
screen goes black when creating or dragging drawing objects ... | Excel Discussion (Misc queries) | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming | |||
Creating remote objects | Excel Programming | |||
How to references objects that exist on local or network drives that aren't open. | Excel Programming |