Cell referencing! help

S

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
 
C

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
 
B

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)
 
F

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.
 
Top