Q. I have some blank rows in my worksheet. Stat/Transfer stops reading the data as soon as it encounters a blank row. Is there any way to work around this?

The reason Stat/Transfer behaves that way is that sometimes users like to put comments or notes at the bottom of their data block. If they put at least one blank line between the data and the comments, then by default, Stat/Transfer will read their data and skip the comments with no special actions on their part.

However if you can change the behavior in one of two ways. In the Options dialog box, you can either set the Blank Rows option to control reading of blank lines, or you can explicitly set a data range by using the Data Range option. In the later case, Stat/Transfer will return all of the rows in the range you specify.