remove row with empty first cell

[VBisgreat]

I have an excel sheet of data, if the first cell of any row is empty, I need a macro that help me cut and paste that row to another sheet.

Thanks,

[D_Rennie]

Hello.

The description of what you require is a little vague.

By the 1st cell in a row, Im guessing the you are refering to the cells in column A.
What will determine the range to be looked at. will all the cells in column B have values, Or will the user select the range to be looked at.

cheers

[VBisgreat]

"By the 1st cell in a row, Im guessing the you are refering to the cells in column A"-- you're correct.

will all the cells in column B have values --Yes!

Thanks

[D_Rennie]

hello,

Try this.

Please Login or Register  to view this content.

hope it helps

[VBisgreat]

First sheet let call it datacheck sheet, second sheet let call it data removed sheet

[VBisgreat]

Thanks alot! but when I change the name of the sheet to the above name, it didn't work, please help!

[VBisgreat]

thanks very much, it's work great!!!