View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pontificateur Pontificateur is offline
external usenet poster
 
Posts: 13
Default Dynamic Columns in Named Ranges

I have set the following dynamic Named Range. Note that the Columns are
static 15, not dynamic as I'd like. There seems to be no "CountA" equivalent
for rows!?

=OFFSET(Template!R2C1,0,0,COUNTA(Template!C1)-1,15)

Can you help? I've searched these postings for all dynamic named-range
info, but it all relates to Rows. I cannot find a Column example. It's
amazing how much time a person can spend on a simple unknown.