DO in column B WHILE column A <>""

[Jeremy4110]

I have a copy, paste, and delete function that I do in column B based on a fixed range (B2:B1000) and most of the time it is way to many and every once in a while it is not enough. What I would like to do is have a variable range for those functions based on the numeric values in column A, like a do-while A:A <>. The numeric value in column A will always be between 1 and 999999. The values in column A are sorted smallest to largest. The function I do in A2 is =IF(A2=A3,"DUP","") than I copy it to the set range. Then I do copy and paste special, values. Then I delete all the rows that have DUP in column B. The values in column A are location numbers that I have to update and I format column A as "000000". I am hoping this will speed up the macro, the delete part of the code takes a while when there are only two rows that actually need to be deleted. (DUP = Duplicate)

Please Login or Register  to view this content.

[pike]

hi Jeremy4110,
Did you mean to post in the test forum or would you like it moved to the excel forum help?

[JBeaucaire]

This should be nearly instantaneous:

Please Login or Register  to view this content.