I did not change anything in the code, I left it as is so I can do that later, after the sheets have been separated.
, but my file path is,
C:\Sohail\LITIGATION PREPARATION-Hanh\ALLOCATION DATA\Hanh Project\6-30-2014\Allocation 2014-2015\Split Allocation\Alloc Rev 2015 Combine_RC Sheets Separate sheets
Thanks
After splitting the sheets, I need to send them to different managers of that departments, and I do not want to send them macro sheets. Would sheets have macro attached to them?
Oh Andrew, you asked wheat error I am getting, please wait, I will run again.
Thanks Andrew.