K
Khusro
Is there any way I can perform calculation on the basis of cell formatting
such as get the sum of highlighted cells
such as get the sum of highlighted cells
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
M
Mike H
How are the cells highlighted, is it conditional formatting or a fill colour?
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
D
Don Guillett
Sub sumselection()'non-contiguous assign to button or shape
MsgBox Application.Sum(Selection)
End Sub
'below ONLY if a contiguous selection.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Application.Sum(Selection)
End Sub
MsgBox Application.Sum(Selection)
End Sub
'below ONLY if a contiguous selection.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
MsgBox Application.Sum(Selection)
End Sub
D
Don Guillett
I probably misread the post but this may still be useful
C
CellShocked
I probably misread the post but this may still be useful
He does know about the stats given on the status bar at the bottom of
the currently selected widow, right?