deleteing rows

Hey, I have a worksheet which contains a different amount of rows used each time but i have dates set up already, once the data is inputed i need to run a macro which deletes all dates that are not used. I fill in data in Column B and i need to delete all rows when column B has a cell with null value, this is what i have:

Please Login or Register  to view this content.

But this isnt working, can someone please help, thanks,

because i send it out to clients, and they fill in the data, i need the dates to be set up the same, so that is why.

Example.ziphere is a copy,

any ideas?

HEy, i have been trying another method here is what i have:

Please Login or Register  to view this content.

Still no luck, I have it selecting the possible entries, however i cant get it to delete the row when the cell is empty.

Your macro finds the last used cell in column B and then steps UP to row 2 looking for blank cells in B and actually will work if it finds a blank cell.
If you are wanting to delete the rows with blank B at the bottom of the sheet of the example you posted it will require finding the last row used in your date column.

how would i set it up to see with the date column?

Using the example sheet you posted I blanked a couple of B cells and ran your original macro.
The rows with blank Bs were deleted.
Then ran this code

Please Login or Register  to view this content.

and all rows at bottom with unused Bs were deleted.

thanks for the help guys i used no sparks solution