Folks,

Pl help me with this simple issue--

For a range of cells in a worksheet- I need to take values from other cells
on the same worksheet but located at a known relative position.

eg: Value in a cell = value in the cell 4 columns to it's right.
I tried =(COLUMN()-4)ROW()
but got an error. Seems straightforward but how can i do it? I need the
relative position as this has to be done on several parts of the worksheet
and a formula with variables would be easier.

use the Offset syntax.
Range("A1").Offset(0,4)

Offset(0,4) = 4 Columns tot he Right
Offset(4,0) = 4 Rows Down
Offset(0,-4)=4 Columns to the Left
Offset(-4,0)=4 Rows Up
Offset(4,4)=4 Rows Down AND 4 Columns to the Right etc ....


Corey....
"ExcelMania" wrote in message
...
Folks,

Pl help me with this simple issue--

For a range of cells in a worksheet- I need to take values from other
cells
on the same worksheet but located at a known relative position.

eg: Value in a cell = value in the cell 4 columns to it's right.
I tried =(COLUMN()-4)ROW()
but got an error. Seems straightforward but how can i do it? I need the
relative position as this has to be done on several parts of the worksheet
and a formula with variables would be easier.

Thanks Corey-I will try this out and let you know.

"Corey" wrote:

use the Offset syntax.
Range("A1").Offset(0,4)

Offset(0,4) = 4 Columns tot he Right
Offset(4,0) = 4 Rows Down
Offset(0,-4)=4 Columns to the Left
Offset(-4,0)=4 Rows Up
Offset(4,4)=4 Rows Down AND 4 Columns to the Right etc ....


Corey....
"ExcelMania" wrote in message
...
Folks,

Pl help me with this simple issue--

For a range of cells in a worksheet- I need to take values from other
cells
on the same worksheet but located at a known relative position.

eg: Value in a cell = value in the cell 4 columns to it's right.
I tried =(COLUMN()-4)ROW()
but got an error. Seems straightforward but how can i do it? I need the
relative position as this has to be done on several parts of the worksheet
and a formula with variables would be easier.