I have a Macro button in my Excel Spreadsheet, everytime I close the spreadsheet it gives me this error "Microsoft Excel Stopped Working"
I have attached Spreadsheet to show example.
Please help.
I have a Macro button in my Excel Spreadsheet, everytime I close the spreadsheet it gives me this error "Microsoft Excel Stopped Working"
I have attached Spreadsheet to show example.
Please help.
Hi, Fredbugatti,
when I disabled the first code line there was no error with my Excel2013. What version of Excel do you use (you mention 2003 in your profile)?
CIao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Works for me in 2007.
One error/mistake is that sFormula is an R1C1 type formula but you insert it as a A1 type formula.
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks