Dynamic Ranges

[Edgar]

Hi

Frank helped me with the following dynamic ranges formula.

=OFFSET(Crystal_Table!$A$1:$H$1,0,0,COUNTA(Crystal_Table!
$A:$A),1)

This now selects all cells in column A and in Row 1 but
not any of the other cells.

For example my sheet has 20 rows and goes up to column H
so I would like the range to be A1:H20

Can anyone help?

TIA

 

[Frank Kabel]

Hi
change this to
=OFFSET(Crystal_Table!$A$1:$H$1,0,0,COUNTA(Crystal_Table!$A:$A))

(remove the last parameter - the width)

 

[Brad]

Change that last 1 in the formula to the number of columns
between and including ColumnA and ColumnH. So 8.

-Brad