View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Display value in excel from module

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

--
Don Guillett
SalesAid Software

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