When you change a color in the palette, it is changed for any element formatted with the color you changed, throughout the entire workbook.
Name Next wksht For i = LBound(wkshtnames) To UBound(wkshtnames) Msg Box wkshtnames(i) Next i End Sub Dim cell As Range Dim sh as Worksheet for each sh in Worksheets(Array("X340", "X342n","X642e")) For Each cell In sh. Text)) = 0 Then Msg Box "There is data missing" & cell. Goto cell, True Cancel = True Exit For End If Next cell Next Sh 0 Then Msg Box "Error " & Err. Description Exit Sub End If On Error Go To 0 If Not rng Is Nothing Then 'dimension to max possible names in array Re Dim arr Names(1 To rng.
Hello friends, In the previous Article, you learnt how to Schedule a Program in Windows.
From HELP -- Each Microsoft Excel workbook has a palette of 56 colors that you can apply to cells, fonts, gridlines, graphic objects, and fills and lines in a chart.
If you are using a color monitor, you can customize the shade and intensity of the colors in the color palette for each workbook.
been transferred from my pathname, lastcell and buildtoc pages.