Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
VB Macro question | Excel Discussion (Misc queries) | |||
Another Macro Question | Excel Worksheet Functions | |||
Macro Question | Excel Discussion (Misc queries) | |||
Macro Question | Excel Programming |