I recorded the above macro to split some data, but when I run the code within a Loop, I get the Alert that asks:
"Do you want to replace the contents of the Destination Cells?
Well, of course I do, that is why I recorded the macro, to replace the contents of the destination cells!!
I used the code:
but this does not always seem to work, the pop-up will still display. ( on test, I have not used "= True" after the action, but it still pops up)
Is "DisplayAlerts = False" the correct code to use on this particular function?