can anyone help me??

I have defined the following dynamic range:

=offset(Grandtitle1,0,1,1,count(Practice!11;11)

The problem is, the row is part of a pivot table, therefore the position of the starting point (named range "Grandtitle1") will move up and down. I want this dynamic range to apply to whichever row the Cell Grandtitle1 happens to be on, as apposed to defining a specific row as it is at the moment (i.e Practice!11:11).

Is there a way that I can have the row referentce at the end to be something like (grandtitle1:end of that row) wherever it may be in the spreadsheet.

If you get what mean and no a way I would greatly asppreciate your help.