Thread: Error Msg into a cell as text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.E. McGimpsey J.E. McGimpsey is offline
external usenet poster
  
Posts: 493
Default Error Msg into a cell as text
one way:

myCell.Value = Err.Description


In article ,
"Stas Timofeyev" wrote:

How can I take the text of an error message and paste it
into a cell to create a report of all errors while running
a macro?
Thanks a lot!
Reply With QuoteReply With Quote