ExcelBanter - Error Msg into a cell as text

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Error Msg into a cell as text (https://www.excelbanter.com/excel-programming/277802-re-error-msg-into-cell-text.html)

J.E. McGimpsey

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!

All times are GMT +1. The time now is 08:50 AM.