Hi,
I am employing the solution at http://www.rondebruin.nl/win/s3/win005.htm in a worksheet to split the data of one massive worksheet into several, based on page breaks.
However, the row height and column widths are not being preserved. I have figured a simple enough way to take care of column widths, but the row heights are tough because they don't follow a pattern.
Is there any way to modify this routine to preserve the column widths and row heights when making the paste operation into the new sheets?
Bonus points: Instead of doing this by page break, how could I do this via every instance of a phrase? Every page in the file has the same title, so maybe I can use that instead of creating page breaks in the first place.
Bookmarks