look one cell below

  • Thread starter Thread starter jpx
  • Start date Start date
J

jpx

Does anyone know how reference one cell below another cell. Example In
cell B10 I want to return the value in the cell below cell A5, but I
can't type A6 directly. I want to type in something like =A(5+1) but
excel doesn't take that. Any suggestions? Thanks!
 
jpx said:
Does anyone know how reference one cell below another cell. Example In
cell B10 I want to return the value in the cell below cell A5, but I
can't type A6 directly. I want to type in something like =A(5+1) but
excel doesn't take that. Any suggestions? Thanks!
Click to expand...

=OFFSET(A5,1,0)
 
DIM ROW,COLUMN AS INTEGER
THE_CELL_I_WANT = cells(ROW+1,COLUMN) 'this should be 1 down for the
reference cell

regards Julian Brotherton.
 
Create a range name in a cell (any cell) called Down1 (or
whatever you like). Then make the range name relative,
you can then use that range name anywhere & any number of
times simultaneously anywhere on THAT sheet (ONLY).
Here's how ;
select cell A1, create a range name in the Name
box "Down1". Excel will create the range using an
absolute address. Now go to Insert>Name>Define and remove
the dollar sign from the address of the range called
Down1, this makes it a relative range name & allows
multiple use.
 
Back
Top