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!!