I have a macro that I need a hand with. The form that users fill out contains 1 string that actually contains 2 different commands I need separated. For example, the text the user puts in is "text1*text2", and I need it to be "text1" and "text2". I wrote in code to do delimited text-to-columns with * as the separator, and that works great but Excel prompts the user with "Do you wish to replace the contents of the destination cells". The answer is always yes, so is there a way I can make it just not pause & ask that?
Bookmarks