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.
|