MS Excel / VBA help thread

You are reading a single comment by @chez_jay 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.

•

chez_jay in reply to @aggi

Then your problem is 'This' here.

For Each wSheet In ThisWorkbook.Sheets

-

I'm guessing I may need to be more specific on which workbook/sheet it should be looking at.

I would suggest keeping the code in a utility workbook, and Calling it from the workbook you want to split, in order to avoid this

About

Avatar for chez_jay @chez_jay started