xhuljano
10-22-2012, 08:21 AM
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!
8974
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!
8974