Display value in excel from module

  • Thread starter Thread starter mniccole
  • Start date Start date
M

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....
 
Sheet1.Range("S5") = OPcount
Change the sheet number to suit,
Regards,
Alan.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Stop Excel from displaying rounded values 4
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
nested IF(OR Vlookup returning zero instead of value in target cel 7
I found Row 14 in wksh 2, can I get the value of J14 into wksh 1? 13
Display excel formula values 4
Centralize worksheet code in Module code 1
UDF's & puzzling recalculation behavior 3

Back
Top