HELP - ROW MACRO NEEDED
Posted by EDDIE G on October 06, 2001 12:18 PM
I have a sheet that has names in column A, numbers in column b and c. I need some kind of looping macro that replaces the below macro that i am currently using. It must insert a row starting at row 3, then cut the figure from C2 and paste it in B3. Then insert a row at row 5, cut C4 and paste it in B5, and so on and so forth all the way through row 1500. The below macro i am using is too long and takes too long to run. Can someone help?
Sub RowInserter ()
etc. etc. etc.
As you can see, if I do this through row 1501, its too long.