MS Excel / VBA help thread

You are reading a single comment by @Drakien and its replies. Click here to read the full conversation.

•

aggi in reply to @Drakien

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.

•

Drakien in reply to @aggi
I think you can save it in your personal workbook, but to run you open both, and then switch to the workbook you want to split, and run the macro from the personal workbook.
```
ThisWorkbook
```
refers to the one with the focus when you run the macro.

About

Avatar for Drakien @Drakien started