View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
havocdragon havocdragon is offline
external usenet poster
 
Posts: 75
Default Need a Macro that will sum Values in a Column that are red

Hey all. I am currently working on a project, and what I need to do, Is sum
the values in a colomn where the fill color is red (or interior.color = 6). I
am not accustomed to using formulas in a macro, but since this will be a
variable range, I need to use a macro, How would I go about doing this?