> When I highlight all of them ...
Do you highlight the cells? If so, then this won't work.
To get it to work, I need to select entire rows (i.e. from the row
number headers at the left of the screen). At that time, the format
painter does do the row heights too.
(Remember that it's ROW height, not CELL height. This means that you
need to work with rows, rather than cells.)
All this in 2003. Don't have access to 2000 to cross-check.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Robert E. Carneal
Sent: Wednesday, 11 January 2012 07:56
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Row Formatting-
Ok. I have rows 1 through 7 set to 13.5 in height.
I have rows 8 through 37 set to a height of 16.5.
When I highlight all of them (mixed heights), and try to format
painter that down the sheet, it does not do anything. It will put the
fonts in those cells, but won't resize.
I am using Excel 2000.
Thank you.
Robert
Genealogy without documentation is mythology! Always SOURCE your work.
On Tue, Jan 10, 2012 at 2:21 PM, David Smart
<smartware.consulting@gmail.com
<mailto:smartware.consulting%40gmail.com> > wrote:
>
>
>
> I just used format painter to copy an area that had merged cells
> (horizontally and vertically) and a tall row. Worked OK in 2003.
>
> What exactly isn't working for you?
>
> What Excel are you using?
>
> Regards, Dave S
>
> ----- Original Message -----
> From: "Robert E. Carneal" <kentuckygenealogist@gmail.com
<mailto:kentuckygenealogist%40gmail.com> >
> To: "excelvba" <excelvba@yahoogroups.com
<mailto:excelvba%40yahoogroups.com> >
> Sent: Wednesday, January 11, 2012 4:56 AM
> Subject: [ExcelVBA] Row Formatting-
>
> > *Suppose I have the following:
> > Rows 1-7 are formatted at 13.5.
> > Rows 8 - 37 are formatted at 16.5.
> > Some cells are merged together.
> >
> > Can I copy the row heights and merged cells *repeatedly* downward
until I
> > reach the bottom?
> >
> > Then I would not have to format the cells and rows as I go along. Is
that
> > possible? I tried format painter, but it won't let me do the merged
> > cells.
> > *
> > *Thank you.
> >
> > **Robert*
> > *Genealogy without documentation is mythology! Always SOURCE your
work.*
----------
Visit our website at http://www.ubs.com
This message contains confidential information and is intended only
for the individual named. If you are not the named addressee you
should not disseminate, distribute or copy this e-mail. Please
notify the sender immediately by e-mail if you have received this
e-mail by mistake and delete this e-mail from your system.
E-mails are not encrypted and cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete, or contain viruses. The sender
therefore does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required please request a hard-copy version. This
message is provided for informational purposes and should not be
construed as a solicitation or offer to buy or sell any securities
or related financial instruments.
UBS reserves the right to retain all messages. Messages are protected
and accessed only in legally justified cases.
[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