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