View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ktoth04 ktoth04 is offline
external usenet poster
 
Posts: 28
Default If certain cells not blank, and cells in range are, set values to

Hi, I'm trying to do the following...

On Sheet 1, where x is rows 13:27
If the values in D,F,H,J,and L for row x are NOT BLANK
set the value of the cells (Nx:Tx) that are blank to zero

Any help, or advice about how to implement any of this is appreciated....
Thanks!