Modify Macro that Pastes Repeatedly

[votekinky06]

I'm using the macro below to find cells with names in a range, and then paste them into column A x number of times. I it to paste until it hits a point where the next iteration of paste begins where there is no data in column F. The number of rows with data in column F is variable, so as it stands right now I'm having set the paste to 150x, and then run a different macro to find blanks in column F and then delete the values in A, which really slows things down. Any help with this will be appreciated.

Please Login or Register  to view this content.

[millz]

Try:

Please Login or Register  to view this content.

[votekinky06]

BEAUTIFUL! Thank you!!

[millz]

No problem, but a quick look at it again found a problem, it will clear 1 row if columns A and F had exactly the same number of rows.

Change the sign:

Please Login or Register  to view this content.