Hi, I found a macro for a task I need to do which splits a single worksheet into multiple workbooks with a set number of rows.
The code incorporates copying the first row (header) of the original worksheet into all the created workbooks. However, since my original worksheet does not have a header, I need this feature removing to stop the first row being reproduced into all the created workbooks, as this row contains data rather than a header. The code is as follows:
I'm a VBA newbie so any help to accomplish this would be great. Thank you!
Bookmarks