Because you are starting at a2 and counting all of a, simply subtract one
=OFFSET(CSV!$A$2,0,0,COUNTA(CSV!$A:$A),13
=OFFSET(CSV!$A$2,0,0,COUNTA(CSV!$A:$A)-1,13
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ken Warthen" wrote in message
...
I'm using the following to set a dynamic range in an Excel 2003 workbook
that
I use to determine records to be exported to a CSV file. My formula is
setting the dynamic range with one extra (blank) row that results in my
CSV
file having a row of commas at the end of the file. That's causing all
kinds
of problems. Any help will be greatly appreciated.

Dynamic range formula
=OFFSET(CSV!$A$2,0,0,COUNTA(CSV!$A:$A),13)