Hi

I need to run code that
finds all the worksheets in my activeworkbook that have the name "AC Planned
Summary" (there could be many with (2) (3) and so on after the name )
and determines if cells C9:C100 are greater than or equal to 0.
If C9:C100 have any values greater than or equal to 0, then the
corresponding cells in E9:E100 need to have a 0 placed in them via this
code.
SO if .. C9 , C10 and C11 all have values greater or equal to zero in
them..then I would need E9, E10 and E11 to have 0 placed into those cells
via this code.

I would use formulas.. but I need to determine the last entry in that
column..and formulas mess that up..

Thanks in advance for your help!!
Kimberly