View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GOL GOL is offline
external usenet poster
 
Posts: 2
Default Deleting Null Cells

I would like a macro that deletes All Null Cells in a spreadsheet.

For Example

aaa Null 123
bbb 123 Null 123

Would look like

aaa 123
bbb 123 123

I would like the Null Cells Delete and everything to come to the left.