I've been experimenting with this a bit. If I copy a worksheet within the same workbook, everything stays the same in Page Layout view. If I copy a worksheet to a new workbook, a couple of rows get dropped off every time. I'm hoping someone can give me an idea as to what may be causing this. It happens if I just used the "Move or Copy" command at the tab on the worksheet or if I do it with code.
Thanks,
Steve
--- In ExcelVBA@yahoogroups.com, "sspatriots" <sspatriots@...> wrote:
>
> Hi,
>
> I've copied some worksheets to a new workbook maintaining all of the formatting, however, when I view it in "Page Layout" view, the new copy has 2 less rows of data. Therefore, the total page numbers on the new workbook's worksheets are different than the source. I've checked the to make certain all the custom margins match on both workbooks and they do, so I can't figure out why the difference. If anyone has any ideas as to something I may have overlooked, please advise.
>
>
> Thanks,
>
> Steve
>
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar