Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doesn't recognize worksheet
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 ActiveWorkbook <---ERROR Doesn't recognize method or property error Any suggestions? Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doesn't recognize worksheet
Give this a try...
For Each Wksht In ActiveWorkbook.Worksheets -- HTH... Jim Thomlinson "davegb" wrote: 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 ActiveWorkbook <---ERROR Doesn't recognize method or property error Any suggestions? Thanks! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Doesn't recognize worksheet
A Worksheet is not a member of Workbook (Workbook isn't a collection and has
no members). A Worksheet is a member of the ActiveWorkbook.Worksheets collection. For Each Wksht In ActiveWorkbook.Worksheets HTH, -- George Nicholson Remove 'Junk' from return address. "davegb" wrote in message oups.com... 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 ActiveWorkbook <---ERROR Doesn't recognize method or property error Any suggestions? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum to recognize new rows | Excel Discussion (Misc queries) | |||
Excel does not recognize text in a worksheet | Excel Discussion (Misc queries) | |||
VBA does not recognize Excel worksheet function "indirect" | Excel Programming | |||
Recognize #div/0! | Excel Discussion (Misc queries) | |||
recognize formatting | Excel Worksheet Functions |