Not tried this yet myself but have you tried Autofil?
If I select a group of cells then autofil, that whole group of cells is copied.
HTH
Lisa
-----Original Message-----
From: Robert E. Carneal <kentuckygenealogist@gmail.com>
To: excelvba <excelvba@yahoogroups.com>
Sent: Tue, Jan 10, 2012 9:02 pm
Subject: [ExcelVBA] Row Formatting-
*Suppose I have the following:
ows 1-7 are formatted at 13.5.
ows 8 - 37 are formatted at 16.5.
ome cells are merged together.
Can I copy the row heights and merged cells *repeatedly* downward until I
each the bottom?
Then I would not have to format the cells and rows as I go along. Is that
ossible? 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.*
[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