Display value in excel from module
 

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

Display value in excel from module
 

Range("S5") = OPCount

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Display value in excel from module
 

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

Display value in excel from module
 

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

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