Hi guys,
I'm trying to use VBA to replace a formula in a particular cell (eventually this will be triggered by a user selecting a particular country). However, to test things out I've just written some VBA using the FormualArray object which sets the formula already in cell H4 (Sheet: "Grpg Logic Engine") back into it.
What's strange is that the formula works well when typed into the cell directly. But when you run the macro (which simply sets the exact same formula back into the cell it returns a 'FALSE' value.
Any insight/help would be much appreciated.
Cheers,
Oscar.
Bookmarks