Macro Question
 

I am trying to write a Macro to sort data in a spread sheet. I hav
alpha numeric part numbers in column B, then an integer from number 1-
in column C. When it encounters a new part number, it inserts a row.
There are supposed to be eight parts for every part number. Some o
the part numbers only have 3 or 4 listings and i am trying to writ
code that will go in and look at column C and if the numbers fo
example go 1,2,3,6,7,8 then it will go in and insert a row for 4 and
and place "spare" in column B. When I import the data i am currentl
telling it to check rows 1-600, i am also trying to code it to where i
will automatically know how many rows are being used and just work o
those rows. As instead of, "For rwindex = 1 To 330" i want somethin
that For rwindex = number being used

--
Drape
-----------------------------------------------------------------------
Draper's Profile: http://www.excelforum.com/member.php...fo&userid=2411
View this thread: http://www.excelforum.com/showthread.php?threadid=37718