Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This code:
Sub CountReasonContactCode() Dim Wksht As Worksheet Dim rReason As Range Dim lRow As Long Dim lCurRow As Long Dim rCell As Range Dim l16Rct As Long Dim l16Act As Long Dim l16BGct As Long Dim lCt As Long Dim lTotNameRow As Long lRow = 107 lTotNameRow = 4 l16Rct = 0 l16Act = 0 l16BGct = 0 For Each Wksht In ThisWorkbook.Worksheets Set rReason = ActiveSheet.Range("D8", Cells(lRow, "D")) For Each rCell In rReason If rCell = "16" Then lCt = InStr(1, UCase(rCell.Offset(0, 2).Value), "R") If lCt 0 Then l16Rct = l16Rct + 1 lCt = 0 End If lCt = InStr(1, UCase(rCell.Offset(0, 2).Value), "A") If lCt 0 Then l16Act = l16Act + 1 lCt = 0 End If lCt = InStr(1, UCase(rCell.Offset(0, 2)).Value, "B") If lCt 0 Then l16BGct = l16BGct + 1 Else lCt = InStr(1, UCase(rCell.Offset(0, 2)).Value, "G") If lCt 0 Then l16BGct = l16BGct + 1 lCt = 0 End If End If End If With Worksheets("Totals") .Range("G", lTotNameRow) = l16Rct<----ERROR gives me an "Object Defined" error at the marked line. Any ideas? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run Time Error 1004 - Application-defined or object-defined error | Excel Programming | |||
Run-time Error 1004: Application-defined or Object-defined Error | Excel Programming | |||
error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error | Excel Programming | |||
Macro Run-time Error 1004 Application Defined or Object Defined Error | Excel Programming | |||
Runtime Error 1004 -- Application Defined or Object Defined Error | Excel Programming |