Simon,
You can just reference it as Cells(R,C) where R is the row
number, C the column number. Use Cells(R,C).Value for the
actual value in the cell.
-----Original Message-----
How do you reference a single cell?...it doesnt have to
be specific just
any cell but without naming it as a range...i.e what ever
column your
in then look at cell in that column say on row 2?

thanks,

simon


---
Message posted from http://www.ExcelForum.com/

.