| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select All Sheets and clear Interior Cell colours
Sub clear_color()
Application.ScreenUpdating = False Dim n As Single For n = 1 To Sheets.Count Sheets(n).Cells.Interior.ColorIndex = xlNone Next n Application.ScreenUpdating = True End Sub Gord Dibben Excel MVP On Mon, 21 Mar 2005 14:16:45 -0800, "ExcelMonkey" wrote: How do you select all sheets in VBA to clear interior colours. When I record it looks like this. However I want to avoid using sheet names like this. Sheets(Array ("Sheet1", "Sheet2", "Sheet3", "Sheet4", "Sheet5","Sheet6" , "Sheet7", "Sheet8", "Sheet9")). Select Sheets("Audit Results").Activate Cells.Select Selection.Interior.ColorIndex = xlNone |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| colours in spread sheets | Excel Discussion (Misc queries) | |||
| How to select Formula cells with red interior? | Excel Discussion (Misc queries) | |||
| How do you select the colours on Microsoft excel colour pallets? | Excel Discussion (Misc queries) | |||
| Can't get sensible clear colours in Excel 2003 | Excel Worksheet Functions | |||
| Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
Threaded Mode
