Dynamic Ranges

E

Edgar

Hi

I have read Debra Dalgleishs article regarding setting
dynamic ranges in excel and have the following formula.

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

This is not quite doing what i want it to do. It is
selecting the all cells in column B with a value in them
but i need it to Select all cells in columns A:H.

Can anyone help?

TIA
 
F

Frank Kabel

Hi
try
=OFFSET(Crystal_Table!$A$1:$H$1,0,0,COUNTA(Crystal_Table!$A:$A),1)
using column A to identify the number of rows
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dynamic Ranges 2
Multiple Dynamic Named Ranges across Columns 3
How I can set dynamic pivot table ONLY when I have enough data point 1
Dynamic Range 2
2D Dynamic Charts 5
Macro defining dynamic named ranges 2
Copy with Advance Filter 1
One extra x axis item that wont go away - can anyone help? 3

Top