| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic range issue
Try to decrease No of rows:
=OFFSET(CSV!$A$2,0,0,COUNTA(CSV!$A:$A)-1,13) Regards, Stefi Ken Warthen ezt *rta: 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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dynamic range based on criteria, within a dynamic range, passed to a function | Excel Programming | |||
| creating a dynamic range based on criteria, within a dynamic range, and passing it to a function | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Dynamic Ranges: Speed Issue | Excel Worksheet Functions | |||
| select dynamic range with dynamic start point | Excel Programming | |||
Threaded Mode
