Also...
..Text is what is displayed in the cell and
..Value is actually what is contained in the cell except when it isn't.
(.Formula and .Value2 are better choices sometimes)

An example: the cell.Value is 1.23456 but the cell.Text is 1.23 because
the cell is formatted as "0.00"
--
Jim Cone
Portland, Oregon USA



"Sean Farrow"
wrote in message
Hi;
could somebody please explain the difference between rang.text and
range.value? When should I use both?
Chers
Sean.