Application defined or Object defined error

Hello all,

I'm writing this macro that takes a location, date and value and displays it in a few different ways. The problem is that in the "Summary Table" Worksheet in the attached file, the macro gives me an error here:

st.Cells(9, k) = repeatNCCount

The objective is to reference the "Exception Grid" worksheet and check if there are more than one cells with a value of "1" each month. The locations are across row 2 labeled 1-83 (To hide their identity).

What I can't get it to do is to display the sum of the sites, with values of <0.50 that occur more than twice a month, on the "Number of repeat non conforming sites" row.

Anyone have any idea as to why that happens? How can I fix it?

Thanks!

PS All the data has been already loaded in the excel file, just hit OK when your'e prompted to! To clarify, whenever a value of <0.50 is detected, it is recorded as a "1" on the exception grid worksheet.
Copy of Matthew_Calcs_DisinfectantResidual-Final.zip

The variable k is never assigned a value so it retains the default value of 0. When you try to refer to a cell having a column number of 0, you get the error. I can't help because I have no idea what you intend k to be.

https://www.dropbox.com/s/ize9j1etz2...dual-Final.xls

https://www.dropbox.com/s/1bpeykvngp...esidual-V2.xls

Those are the two different versions I'm experimenting with. It's all the same code up until the part where it's giving me an error.

Basically, I need it to look at the exception grid worksheet, check each month individually and record how many locations, in that month, have the value of "1", in the exception grid, appear more than once. It works for some months, but for others it doesn't. (That's the V2 file that works but is inconsistent. The "Final" file doesnt work at all.