Thread: Delete Empty Cells in a Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
fak119 fak119 is offline
external usenet poster
  
Posts: 21
Default Delete Empty Cells in a Macro
1) In a range of cells (A1:B119) there are empty lines (e.g. A1:B1) which I
want to delete in a Macro. Is this possible?

2) When I sort a.m. range of cells (A1:B119), containing text, the empty
lines are on top, unless I sort descending. A way out of this other than
manually delete the emtpty cells? Hence question no. 1
Reply With QuoteReply With Quote