View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rbel rbel is offline
external usenet poster
 
Posts: 2
Default Find blank cells and clear adjacent range


While I know how to find blank cells and delete complete rows, how do I
find all the blank cells in column C and clear the cell contents of the
next 5 cells to the right?

Grateful for some advice.
--
rbel