Just got through finally figuring out what was causing, just don't understand why. For some reason, it did not like the page breaks that were being copied over. I added some code to reset the page brakes and tinkered with the exact location until I ended up with consistency in the number of rows on the copied worksheets on the new workbook.
Even though I didn't have any hidden rows, I surely wouldn't have thought of that. Thanks.
Thanks,
Steve
--- In ExcelVBA@yahoogroups.com, cynt2000@... wrote:
>
> Hi Steve
>
> Did you check and make sure you don't have any hidden rows or columns.
>
> Cynthia
>
>
> In a message dated 9/27/2011 8:40:25 P.M. Eastern Daylight Time,
> sspatriots@... writes:
>
>
>
>
> 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_ (mailto: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
> >
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
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