how to delete indivudal cells

Originally Posted by tweacle

Can someone advise me if I have this correct if I want to delete CELLS in row "M".

M is a column.

If you explained in detail what should be deleted under what conditions, it would be easier to help you achieve your goal.

Does the code you posted do what you want? If not, what does it do/not do that you don't like?

Sorry what im trying to do is if the cells in column M and N are blank I need the data from the cells below to be copied into them and then the row below to be deleted.

I.E If cells in M10 and N10 are blank I need the data from M11 and N11 to be copied into M and N 10 and then row 11 to be deleted.

If poss I need this to run right the way down the worksheet. until the end.

I think this will do what you want. Note: it copy/deletes if BOTH M & N are empty.

Please Login or Register  to view this content.

Many Thanks

You're welcome.