View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
electricbluelady electricbluelady is offline
external usenet poster
 
Posts: 10
Default Fill in zeros within a specified range

Hi everyone,
I have a range of 30 cells in a column, but most have numbers, and some are
blank. I need to write a procedure to replace blank cells with zeros, and to
skip over existing numbers. I need to keep this within the 30 cells in my
range. Any help would be greatly appreciated!
Thank you,
Electricbluelady