Hi there, I am relatively new to VBA.
I recorded a macro to insert an IF formula into a cell:
Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
(I know, it's messy)
When I use the formula manually in Excel, it works perfectly, but when I run the recorded macro it give me a run-time error '1004': Application or object-defined error.
Anyone have a better way of doing a nested IF?
I have to use VBA because it is a large file which is automatically updated each week.
Thanks for your replies!
Bookmarks