Thansk So much...Works perfect.
Have a great day....

Alan wrote:
Sheet1.Range("S5") = OPcount
Change the sheet number to suit,
Regards,
Alan.
"mniccole" wrote in message
oups.com...
Hi:
How would I display the value of OpCount in S5?

ElseIf ActiveCell.Value = "OP" Then
OPCount = OPCount + 1

from my module into my existing workbook cell s4?

I've looked around & can't seem to find the solution & I know it's got
to be easy...
Thanks....