help with looping range and extracting value
Pb21 wrote:
I want to sum the values in a range and have the following code:
Dim Total As Integer
For Each c In Worksheets("Error Codes").Range("T10:T45").Cells
Total = Total + c.Value
Next
ErrorCount = Total
I added a watch to c and the looping works or at least appears to yet
it wont extract a value despite the column t10 onwards having values.
Regards in advance for assistance.
Peter
"extract a value"???
Alan Beban
|