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> 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>
> To: "excelvba" <excelvba@yahoogroups.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.*
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