Copy Qualifier

torweb

Board Regular
Joined
Dec 1, 2003
Messages
136
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...!
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
60,836
Office Version
  1. 365
Platform
  1. Windows
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:

Code:
If Len(ActiveCell)=0 then
   Exit Sub
Else
' proceed with copy
End if
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,151,896
Messages
5,766,992
Members
425,392
Latest member
Booknerd

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top