*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> 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@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.
>
[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