code to 'put' calc displayed in message box in cells
Without seeing the code.................shrug shoulders<g
Your code does a count and that count is displayed in a msgbox.
Just redirect the count to a cell like count = Range("A1").Value
Example code.............
Sub sheets_num()
MsgBox ThisWorkbook.Sheets.Count 'will display in msgbox
Range("A1").Value = ThisWorkbook.Sheets.Count 'will be entered in A1
End Sub
Gord Dibben MS Excel MVP
On Wed, 4 Feb 2009 14:42:31 -0800, shaz0503
wrote:
All
Apologies about the title - hard to describe
I have borrowed a terrific bit of code to count emails in specific folders;
however the count result is only displayed in a message box - how do i get
the result 'put' to a specific cell.
|