bob1122
08-25-2008, 09:13 AM
When I try to compile the following, I get a compile errer.
Sub metric()
kount = WorksheetFunction.Count(b:b)
MsgBox kount
End Sub
Excel will execute Count(b:b) and correctly count the number of rows in Column B that contain numeric data. The VBA compiler doesn't recognize the range (b:b) as valid. Is there another way to determine the count? Thanks.
Sub metric()
kount = WorksheetFunction.Count(b:b)
MsgBox kount
End Sub
Excel will execute Count(b:b) and correctly count the number of rows in Column B that contain numeric data. The VBA compiler doesn't recognize the range (b:b) as valid. Is there another way to determine the count? Thanks.