View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tatakau Tatakau is offline
external usenet poster
 
Posts: 8
Default Getting Started - Referencing Cells

Hey,

I've been coding a bit in Access lately, so I know the basics of VB. What I
don't know is how to reference specific cells. I know that the current
column is '.column', and the current row is '.row', and the value of the
current cell is '.value'.

I am trying to assign a value to the cell right below the current cell. I'd
like to do something like this:

(.column, .row + 1).value = 2 * x + 1

Anyone know how to code this?

Thanks!

Nick