Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic column width
I have one worksheet with all my cells having the proper width and
height... Also I have about 100 worksheets that are identical to the 1st one except the information that goes in cells. What I need is a way to automaticlly adjust all other worksheets so they are all the same as the 1st one that has all columns and rows adjusted.... Hope it is clear. Thank you very much in advance... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic column width
Sub formatsheets()
worksheets("Master").Cells.Copy for each sh in Worksheets if lcase(sh.Name) < "master" then sh.Cells.Pastespecial xlFormats end if next end sub This does more than copy row heights and column Widths - it copies all formatting, so if that is OK test it on a copy of your workbook. NO MERGED cells. -- Regards, Tom Ogilvy "Monte0682" wrote: I have one worksheet with all my cells having the proper width and height... Also I have about 100 worksheets that are identical to the 1st one except the information that goes in cells. What I need is a way to automaticlly adjust all other worksheets so they are all the same as the 1st one that has all columns and rows adjusted.... Hope it is clear. Thank you very much in advance... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatic bar width in stacked column chart too thin | Charts and Charting in Excel | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
Set Column Width Based On Total Width Of Other Columns | Excel Programming | |||
Automatic column width adjustment | Excel Worksheet Functions |