VBA/Row number/column numer

[mika.]

If I want to specify a cell in VBA but only know it's row
NUMBer and not column number, how would I describe this
cell in vba? i.e. instead of AA5, i want to be able to
talkb about it as being column 27 and row 5...

thanks!

 

[Earl Kiosterud]

Mika,

Cells(Row, Column)

Cells(2, 3) would give you cell C2

 

[Chip Pearson]

You can use Cells. E.g.,

Cells(5,27).Value =123