VBA code finds blanks, but how to write VBA to ignore non blanks?

Ok Gurus, I’m crying uncle. I’ve been trying to figure this out and am still stuck.

I have a simple sheet that paste data into. Then I use a button to look at columns A & B to see if there are any blank cells. Then if there is a blank cell it will look to the cell directly above it and copy the data into it. This works perfectly. However if there are no blank cells, how can I write to code to ignore the instructions and move forward? I’ve tried “On error resume next” but I think my placement is off, perhaps the way I have the code now is not structured properly. I would greatly appreciate any guidance. This forum has always been such a fantastic resource and I am so grateful for the kindness I find here. Thank you!

I’ve uploaded a sample sheet, with two tabs. One has data with blanks and one without. Thank you again for taking a look!

No, it is the right code. If the code finds no blanks, it does not error.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kind regards
Leo