Howdy - First post on ANY online forum - New member with limited Excel experience but getting better the more I try.
Running Windows7; Excel 2007 with Trust access to the VBA project object model checked.
Below are macros used for this discussion.
I want function results to return a Blank cell value if the function is FALSE.
The macro “PasteFormulas1()” Pastes and processes appropriately returning a 0 (zero) when a function is FALSE.
The macro “PasteFormulas2()” stops with a message displays stating it was stopped because of a Run-time error “1004” — Application-defined or Object-defined error. The code line with the function was highlighted in vba window.
HOWEVER, After running the “PasteFormulas1()” macro I can either alter the function syntax that were pasted in the Worksheet to the “PasteFormulas2()” syntax
or
from a Text file Cut and Paste the “PasteFormulas2()” function syntax
and the function processes correctly and return a Blank cell value if the function is FALSE.
Thanks for any ideas as to why the “PasteFormulas2()” will not run and/or a solution.
Bookmarks