I have a VBA code to send emails automatically on cell value change. It works perfectly with dummy email addresses in the TO: field, but I want it to send to addresses generated by an IF function.
The VBA doesn't like the cell reference because it contains formula. How do I get around it?
The VBA doesn't like the cell reference because it contains formula. How do I get around it?