Hi Garry

Speed isn't really an issue. Even on the slowest laptops we have the time
taken to process the code is negigible.

--
Ian
--

"GS" wrote in message
...
Mike S laid this down on his screen :
On 8/17/2010 2:04 PM, Jim Cone wrote:
Why do you need 90 + Set statements?
If you already have named ranges why not use them...
If Worksheets("Lookup").Range("Sludge").Cells(2, 1).Value 100 Then
'do something
End If

Has anyone done a speed test to see if there is any appreciable
difference between using the two?

I agree with Jim's comments. Typically, referencing the objects directly
doesn't add to resource overhead, AND also usually results in greater
speed because VB[A} doesn't have to allocate resources required when
storing refs in variables.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc