Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum partucular cells by colour of sheet
Hi,
I have several sheets of different tab colours, ie, 5 green, 10 blue, etc. I need to be able to sum all 'A1' cells together if they are on a particular coloured tab, ie, "What is the sum of all Blue tab sheets cell A1?" I would appreciate any help, Many thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum partucular cells by colour of sheet
Hi Geoffers
Here's an example code: N = 0 For Each s In ThisWorkbook.Worksheets If Worksheets(s.Name).Tab.ColorIndex = 11 Then N = N + Worksheets(s.Name).Range("A1") End If Next s MsgBox "Sum of cells A1 in dark blue tab sheets is " & N HTH Cordially Pascal "Geoffers" a écrit dans le message de ... Hi, I have several sheets of different tab colours, ie, 5 green, 10 blue, etc. I need to be able to sum all 'A1' cells together if they are on a particular coloured tab, ie, "What is the sum of all Blue tab sheets cell A1?" I would appreciate any help, Many thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum partucular cells by colour of sheet
Thank you very much.
"papou" wrote: Hi Geoffers Here's an example code: N = 0 For Each s In ThisWorkbook.Worksheets If Worksheets(s.Name).Tab.ColorIndex = 11 Then N = N + Worksheets(s.Name).Range("A1") End If Next s MsgBox "Sum of cells A1 in dark blue tab sheets is " & N HTH Cordially Pascal "Geoffers" a écrit dans le message de ... Hi, I have several sheets of different tab colours, ie, 5 green, 10 blue, etc. I need to be able to sum all 'A1' cells together if they are on a particular coloured tab, ie, "What is the sum of all Blue tab sheets cell A1?" I would appreciate any help, Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect sheet allowing grouping and ungrouping but alsoallowing changing colour of specific cells | Excel Discussion (Misc queries) | |||
Changing all cells in one colour to a different colour | Excel Discussion (Misc queries) | |||
Sheet Background Colour | Excel Discussion (Misc queries) | |||
can i calculate the number of occurances of a partucular value? | Excel Worksheet Functions | |||
Change Sheet Tab Colour | Excel Discussion (Misc queries) |