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/

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/

try
x=cells(2,activecell.column)

--
Don Guillett
SalesAid Software

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

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/

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/

.