When do you need .Value?
I seem to be having problems with OE lately. The message got sent before I
was finished.
Anyway, a point to make is that Range by itself uses the first Area of it's
Areas collection.
Here's a demo. This has two cells in the Range, ... A1 & D1. One would
think that item(2) should return the number 4. However, it returns 2
because it only looked in Areas(1) and extended its search down.
Sub Demo()
[A1] = 1
[A2] = 2
[D1] = 4
Debug.Print Range("A1,D1").Item(2) ' Returns 2
End Sub
--
Dana DeLouis
Using Windows XP & Office XP
= = = = = = = = = = = = = = = = =
<snip
|