I prefer to use Cells as to Range, its easier when you work with looping
procedures i.e.
Dim y as lnteger
Dim y as Integer
For x = 1 to 10
y =y +1
cells(x,y) = x
Next x
Pretty pointless results from this but this wouldn't be as simple to achieve
using range
--
Message posted via
http://www.officekb.com