Selasa, 27 September 2011

Re: [ExcelVBA] Re: & My last Topic today.... Copied Worksheets have less rows...

 

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@yahoo.com 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]

__._,_.___
Recent Activity:
----------------------------------
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

----------------------------------
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar