B
Bob
I'm getting an error message when the following line attempts to execute:
x = CountIf(Worksheets(Sheet1Name).Range("H" & Sheet1RowPointer & ":U" &
Sheet1RowPointer), ">0")
Sheet1Name is Dim'd as String. Sheet1RowPointer is "Dim'd as Integer.
I'm simply trying to count the number of cells that contain a value >0 for a
given row between columns H & U, inclusive, and assign the result to "x".
Can someone tell me how to fix the aforementioned line so it will work
correctly?
Thanks in advance for the help.
x = CountIf(Worksheets(Sheet1Name).Range("H" & Sheet1RowPointer & ":U" &
Sheet1RowPointer), ">0")
Sheet1Name is Dim'd as String. Sheet1RowPointer is "Dim'd as Integer.
I'm simply trying to count the number of cells that contain a value >0 for a
given row between columns H & U, inclusive, and assign the result to "x".
Can someone tell me how to fix the aforementioned line so it will work
correctly?
Thanks in advance for the help.