Selasa, 10 Januari 2012

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

[Non-text portions of this message have been removed]

__._,_.___
Recent Activity:
----------------------------------
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

----------------------------------
MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

.

__,_._,___

Tidak ada komentar:

Posting Komentar