You are reading a single comment by @Drakien and its replies.
Click here to read the full conversation.
-
I was running it in my personal workbook. Running it in the workbook that I want to split does work (but obviously isn't that practical). I'm guessing I may need to be more specific on which workbook/sheet it should be looking at.
@chez_jay Turning off the alerts doesn't give any errors. I suspect it's down to the file location.
aggi
@Drakien
Are you running the macro in a separate file, or in the file you want to split?