I need macro for deleting blank cell along with another one cell.

[nur2544]

I need macro for deleting blank cell along with another one cell. If B1 is blank then Delete both A1:B1, other than they will be remain as before. Again if B10 is blank then Delete both A10:B10, and same way this procedure will be continue till last blank cell..

[johncassell]

Assuming you only want to look down one columns..

Please Login or Register  to view this content.

[nur2544]

Hi, johncassell. it is not working

Please Login or Register  to view this content.

it will be like range B1:B1000 . here any cell of the range B1:B1000 is blank then delete repective A1:A1000
say for exemple,if cell B1 is blank , & along this A1 having data. as B1 having blank i will be ignore A1 also. so i need to delete both of cell B1 & A1
and like this till range B1:B1000

[kvsrinivasamurthy]

try this code.

Please Login or Register  to view this content.

[nur2544]

Hi, kvsrinivasamurthy
Perfect , it works very well, thanks for your valuable time for me ..

[jolivanes]

Here is another one that works on empty cells in Column B only.
That's the way I understood your question in Post #1.
It does not delete anything if a cell in Column A is empty

Please Login or Register  to view this content.

[nur2544]

Hi, jolivanes
Your solution is also great, my requirement is fulfillment. thanks for your time..