MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Option Explicit Function CountByColor(CellColor As Range, SumRange As Range) Dim myCell As Range Dim iCol As Integer Dim myTotal iCol = CellColor.Interior.ColorIndex For Each myCell In SumRange If myCell.Interior.ColorIndex = iCol Then myTotal = myTotal + 1 End If Next myCell CountByColor = myTotal End Function
|Excel 2010: VBA Macro that Automatically Zooms in and Out & highlights your cell selection upon clicking the cell.||5||48|
|Concatenate strings with original parameters||21||41|
|i'm trying to create pivot table using source data using macro script which i recorded and given below. when i run it i'm getting debug error. could anyone help to fix this issue||10||27|
|Excel VBA Find Lowest Row number in any selection||8||21|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
16 Experts available now in Live!