Hi Matthew
AFAIK it is not possible with a Non Contiguous Range
--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl
"Matthew Wieder" wrote in message ...
Certainly that works, but the idea behind using the Cells collection is
not to have to know or worry about how many cells are in each Area to
get to the 4th cell. As you have pointed out, if I can hard code it, I
don't have an issue.
Ron de Bruin wrote:
Try this small test
Sub test()
Dim rng As Range
Set rng = Range("V31:W31,Y31:Z31")
MsgBox rng.Areas(2).Cells(1).Value
End Sub
You can use this without a loop to make the value 5
Range("a1:b1,d1:E1").Value = 5