Simon,

Try something like

Dim Rng As Range
Set Rng = Cells(2,ActiveCell.Column)
Rng.Value = 123


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"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/