Probably a stupid question.

I can dynamically name a columular data range using the InsertNameDefine
=OFFSET(Sheet!$A$1,0,0,COUNTA(Sheet!$A:$A) function. This allows me to add
data to a list and the named range automatically takes the new data into
account, very handy indeed.

Problem is I need to apply the same dynamic range to a table of data, not
just a single column, so it needs to recognise new data in the rows below and
to columns to the right of the named range.

I tried changing the COUNTA(Sheet$A:A) part of the formula to take the other
columns of data into account (I.e. COUNTA(Sheet$A:ZZ) but it doesn't
recognise this as a valid range.

Any idea how to do this?