To select an entire row, click on its row number at the left of the
screen.
You can use Ctrl-click or Shift-click on other row numbers as usual to
extend the selection.
Regards, Dave S
________________________________
From: ExcelVBA@yahoogroups.com [mailto:ExcelVBA@yahoogroups.com] On
Behalf Of Robert E. Carneal
Sent: Wednesday, 11 January 2012 11:17
To: ExcelVBA@yahoogroups.com
Subject: Re: [ExcelVBA] Row Formatting-
*No.... I didn't know/realize I could select ENTIRE rows. I had been
selecting just a group of cells. Let me try that, and see if I get what
I
am looking for. If I don't I will upload it. This sure is frustrating!
Thank you.
Robert
*
On Tue, Jan 10, 2012 at 5:51 PM, <david.smart@ubs.com
<mailto:david.smart%40ubs.com> > wrote:
> **
>
>
> Just confirming that you do select the entire rows before using the
> format painter, not just a group of cells?
>
> (I can't help with 2000, but why not upload the example to the files
> area, and then people can have a play.)
>
> Regards, Dave S
>
> ________________________________
>
> From: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
[mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com> ]
On
> Behalf Of Robert E. Carneal
> Sent: Wednesday, 11 January 2012 09:31
> To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
> Subject: Re: [ExcelVBA] Row Formatting-
>
> *That is my problem. Format painter in my Excel 2000 does not seem to
> set
> row height. I wonder if I need to set something else somewhere?
>
> If it helps anyone to answer my question I can send someone a one
sheet
> example of what I am trying to do.
>
> Thank you.
>
> Robert
> *
> On Tue, Jan 10, 2012 at 4:25 PM, <david.smart@ubs.com
<mailto:david.smart%40ubs.com>
> <mailto:david.smart%40ubs.com> > wrote:
>
> > **
> >
> >
> > > 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%40yahoogroups.com>
<mailto:ExcelVBA%40yahoogroups.com>
> [mailto:ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
<mailto:ExcelVBA%40yahoogroups.com> ]
> On
> > Behalf Of Robert E. Carneal
> > Sent: Wednesday, 11 January 2012 07:56
> > To: ExcelVBA@yahoogroups.com <mailto:ExcelVBA%40yahoogroups.com>
<mailto:ExcelVBA%40yahoogroups.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.
>
[Non-text portions of this message have been removed]
----------
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