Copy Qualifier

[torweb]

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...!

 

[Joe4]

If you have a cell that you know will always have a value if the row isn't blank, it will make things much easier. Then just use a simple IF statement, checking the length of that cell, something like:

If Len(ActiveCell)=0 then
   Exit Sub
Else
' proceed with copy
End if

 

[torweb]

Thank you...worked great!