Display value in excel from module

[mniccole]

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....

 

[Bernard Liengme]

Range("S5") = OPCount

 

[Alan]

Sheet1.Range("S5") = OPcount
Change the sheet number to suit,
Regards,
Alan.

 

[mniccole]

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

 

[Don Guillett]

sheets("sheet1").range("a1")=opcount