Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting a work book
Hi...
I have a workbook with 45 sheets in it. I want to set the cell aligment of all these sheets to wrap text and to set the font to aerial 10. This code would be run from a macro button on a summary sheet within the same workbook. I'm dead on my feet formatting each page. Any ideas would gratefully received. Thanks Gordon. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formatting a work book
This should do it... For i = 1 To Sheets.Count With Sheets(i).Cells .Font.Name = "Arial" .Font.Size = 10 .WrapText = True End With Next i Hope that helps -- R-Enem ----------------------------------------------------------------------- R-Enemy's Profile: http://www.excelforum.com/member.php...fo&userid=1673 View this thread: http://www.excelforum.com/showthread.php?threadid=31935 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
work book to work book | Excel Discussion (Misc queries) | |||
Locate duplicates in a work book by using conditional formatting | Excel Worksheet Functions | |||
Locate duplicates in a work book by using conditional formatting | Excel Worksheet Functions | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel | |||
simultaneously work in a work book with other users | Excel Discussion (Misc queries) |