Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format all sheets in a workbook
Hi
I've already had a partial answer to this but it didn't work because I think I wasn't specific enough. Here goes again. I have 45 sheets in my workbook. I desperate for code that will allow me to format all sheets in my workbook at once, at the same time so that cell allignments allow for wrap cells and ariel font 10. The code below kindly provided only formats one sheet at a time. I'm using Office 2000. Any help would be great. For i = 1 To Sheets.Count With Sheets(i).Cells ..Font.Name = "Arial" ..Font.Size = 10 ..WrapText = True End With Next i Thanks Gordon. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format all sheets in a workbook
With a macro you must loop
Manual you can select all sheets(group) Do your things Ungroup -- Regards Ron de Bruin http://www.rondebruin.nl "Gordon" wrote in message ... Hi I've already had a partial answer to this but it didn't work because I think I wasn't specific enough. Here goes again. I have 45 sheets in my workbook. I desperate for code that will allow me to format all sheets in my workbook at once, at the same time so that cell allignments allow for wrap cells and ariel font 10. The code below kindly provided only formats one sheet at a time. I'm using Office 2000. Any help would be great. For i = 1 To Sheets.Count With Sheets(i).Cells .Font.Name = "Arial" .Font.Size = 10 .WrapText = True End With Next i Thanks Gordon. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apply Conditional Format to all sheets in same workbook | Excel Discussion (Misc queries) | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Format all sheets in one Workbook | Excel Discussion (Misc queries) | |||
Sheets select method fails when workbook is opened by another workbook | Excel Programming |