ExcelBanter - using cell offsets

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - using cell offsets (https://www.excelbanter.com/excel-programming/441220-re-using-cell-offsets.html)

Jerry Flatto

using cell offsets

Thank you very much.

Jerry

"Barb Reinhardt" wrote:

--
HTH,

Barb Reinhardt

=offset(currentcell,#Rows,#Columns)

If you do this

=OFFSET(C2,2,3)

you will be 2 rows below and 3 columns to the right of C2.

Does that help?

Barb Reinhardt

All times are GMT +1. The time now is 11:14 PM.