Copying row heights cross workbook

[Screamer]

Hi,

I currently have a Macro that copies filtered content and the headers above, as well as column width, to a new workbook. However I would also like to copy the row heights, I hoped copying formatting would do that but it does not seem to work.

Any help would be greatly appreciated,

Thanks,

Stephen


Below is the code I currently have (I know it would be easier to paste special column widths then copy them individually, but after I recorded the macro and implemented it I kept getting errors so I went for this instead):

Please Login or Register  to view this content.

[Leith Ross]

Hello screamer,

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here