I am running into a "Run Time Error 1004 Application-Defined or Object-Defined Error" on the following line of code and cannot figure out why my macro is crashing (It works fine on another computer).
Any idea why this might not work in Excel 2019?
Please Login or Register to view this content.
You say 2019 in the post, your profile says 2007 which version is it?
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Syntax error?
This worksPlease Login or Register to view this content.
Thank you. That worked! Now I am having trouble with this, though:
Please Login or Register to view this content.
Well why don't you just record a macro and do the replace thing, then you have the code and can edit it from there
rjj920,
2007 has no xlFormula2 property, so remove it like
Please Login or Register to view this content.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks