Named range offset by row

**Macdave_19** · 02-05-2008, 08:46 AM

Hi All i want to create a named range that can be offset by a given number of rows (the value in cell A1).

I am using these named ranges in graphs and they need to be by rows due to a complex macro that is already in place.

=OFFSET(GUTO!$A$2,0,0,COUNTA(GUTO!$A:$A),1)

i know the above will obtian all data in a column but i want to be able to pick from a select number of rows!!

please help!!

**jasoncw** · 02-05-2008, 10:47 AM

If I understand correctly, you should just be able to replace the first 0 with the cell reference:

=OFFSET(GUTO!$A$2,$A$1,0,COUNTA(GUTO!$A:$A),1)

HTH

Jason