I have a small userform that lets my user copy and paste a row of cells to another worksheet (or they can cancel the operation). The problem I ran into is if the user accidently clicks the copy button, it adds a blank row of data to the other worksheet and when that worksheet is sorted it now contains blank rows within the other rows of data.
My question is, what will it take to add an error trap that checks the row before copying, and if it's blank, aborts the copy.
Thank you as always...!
My question is, what will it take to add an error trap that checks the row before copying, and if it's blank, aborts the copy.
Thank you as always...!