*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> 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@yahoogroups.com] On
> Behalf Of Robert E. Carneal
> Sent: Wednesday, 11 January 2012 09:31
> To: ExcelVBA@yahoogroups.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> > 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@yahoogroups.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>
> > 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]
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