Cutting a row with conditions

I have a macro that will cut and paste a line to another tab but I want to add a layer. I want to only allow it to work if there is text entered in column "B" of that row. If there is no text, I want a message box that pops up and says "must enter..." and does not execute the macro. Is this possible?

Please Login or Register  to view this content.

That is bringing up the text box even when there is text in that cell in that column??? Also, you stated "or to whatever row you end at". My code is to cut that row and that row only if nothing is in that cell in that particular column. So would that be 1 to 1??

Hi, the above assumed you wanted to start looking in cell B1 to check if there is any text in the cell, if you are starting at B2 you will need to change x = 1 to 10 to x = 2 to 10

The x = 1 to to 10 part above is just the rows it goes through and checks to see if the cell is blank, not the rows you want to delete, that bit is in the part I can see in your original code which I thought you would want to keep.

Feel free to upload a template without any personal info if this hasn't helped!