Seems as though i have some debuggin to do....

If starting with only one blank line, DATALINES reports 1 and ends
OPEN envent. But when you wnter data it tries to insert a line at
row3.

Also if I start with more thank 1 line of data, (1 full and one Balnk)
it goes into a endless loop. (Never returning a BLANK value from
CHKROW)

I think the problem might be in the countblank, before that line,
do I need to some how select the Sheet I wan to count blanks on?




On Wed, 10 Nov 2004 21:03:59 +1300, "Rob van Gelder"
wrote:

I downloaded your workbook.

You put the code in the sheet code instead of the ThisWorkbook code.

To Check if it's running, insert a line like:
MsgBox "Hello World"

Or just set a breakpoint (F9). Another way to set breakpoint is from the
Debug menu, select Toggle Bookmark.

Another thing, get into the habit of using Option Explicit. It'll save you
hunting bugs.
From Tools | Options, select "Require Variable Declaration"