Slowness adding rows using VBA

[tmetherd]

I have less than 1000 rows in the attached worksheet ("AUCTIONS") tab. I am already experiencing slowness when I use the "ADD" button for my form. This has gradually continued to get slower so I am concerned that my code may be more complicated than required. Especially the subs "cmdAdd_Click" and "cmdSearch_Click"

Thanks in advance for the help.

[Norie]

What is the purpose of the advanced filter in the cmdAdd_Click sub?

That's what's slowing things up.

[tmetherd]

I was using the procedure to copy all non-blank cells on worksheet AUCTIONS and paste to worksheet TEMP where the data can be manipulated and pasted back to AUCTIONS. It was much easier to use this procedure instead:

Please Login or Register  to view this content.