Cell referencing! help

[Simon Lloyd]

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

 

[Chip Pearson]

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

 

[Don Guillett]

try
x=cells(2,activecell.column)

 

[Bob Phillips]

Cells(2, Activecell.Column)

--

HTH

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

 

[FMcC]

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.