ok, that's a great help, but, does that only search column "B" for data
in the ninth row?

Here's what the spread sheet looks like...

I want to make sure there are only 8 lines of data for each analyte...
so the user enters a ninth row for each analyte, they press the run
macro button, then it searches range C3 to O11.. realizes theres a
ninth row, deletes the row 3, adds a new row under 11(no it would be
10, because it all moved up). Then, it goes to search next range, C14
to O22.. ... keeps up this pattern through the whole spreadsheet.

I just dont know how to write that into the Range() because the way
i've been writing the data into the () is wrong since i keep getting
error msgs.

I thought if i wrote
numRows = numRows + Application.WorksheetFunction.CountA(Range(CI:OI+8 )
where I is a variable that changes in the loop and in this it
represents the row. I know the format in the Range part isnt right at
all .. that's what i need help with....

thank you sooo much if you can give me a hand!

File Attached: http://www.excelforum.com/attachment.php?postid=330425 (samplesheet.xls)

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/