Cells(2, Activecell.Column)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Simon Lloyd " wrote in 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/