I found this macro on the net, and I adapted it to grab a dynamic number for the row divisions ("Pages" public variable) problem is row 1 is repeated at the top of each page, so the first sheet has one less row then the rest of the sheets so i end up with the last sheet having one row on it. anybody know where the problem is? any help would be much appreciated

Thanks,

Chris

Please Login or Register  to view this content.