I cant for the life of me figure out how to do this.

I'll attach a sample of the code that i've written so far, just for a
better idea of what i'm talking about.

Basically I would like this bit to count the number of rows with data
in them. Then, move to the next range of data and do the same thing
over again... I cannot find how to write that in the "Range" part. I
can make it work for doing it once because I used "cells" and make it
do 9 iterations, but i would rather it look at the whole row for data,
and then skip to the next area in my program, which is 3 lines down
from this first range of data... I'm not too good at explaining...
Could someone please help me??
Thank you.

Sub row_manipulation()

Dim I As Integer
Dim numRows As Integer
numRows = 0

For I = 2 To 100
numRows = numRows +
Application.WorksheetFunction.CountA(Range(******* )) 'checks to see if
a ninth row (new data)is entered

If numRows = 9 Then
Rows("I:I").Select 'select the first data row and delete
Selection.Delete Shift:=xlUp
Rows("I+8:I+8").Select 'insert new empty row for next time data is
entered
Selection.Insert Shift:=xlDown
End If
I = I + 11 'skip to next analyte
Next I


End Sub



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