View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default code to 'put' calc displayed in message box in cells

If you're working on the activesheet, do something like this

=activesheet.range("C1").value = ... enter your value


--
HTH,
Barb Reinhardt

If this post was helpful to you, please click YES below.



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