Dynamic Ranges

  • Thread starter Thread starter Edgar
  • Start date Start date
E

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
 
Hi
change this to
=OFFSET(Crystal_Table!$A$1:$H$1,0,0,COUNTA(Crystal_Table!$A:$A))

(remove the last parameter - the width)
 
Change that last 1 in the formula to the number of columns
between and including ColumnA and ColumnH. So 8.

-Brad
 
Back
Top