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?