Microsoft Office Tutorials and References
In Depth Information
Applying SUM / COUNT by Color
' * * * * *¶
Sub RemoveHyperlinksSheet()¶
Dim WS As Object¶
'Change the following variables¶
'Apply to a particular sheet¶
'Set WS = ActiveWorkbook.Sheets("Sheet1")¶
'Use the current active sheet¶
Set WS = ActiveSheet¶
End Sub¶
' * * * * *¶
Sub RemoveHyperlinksRange()¶
Dim Rng As Range¶
'Change the following variables¶
'Apply to a particular range¶
'Set Rng = Range("A1:E20")¶
'Use the current selection¶
Set Rng = ActiveWindow.RangeSelection¶
End Sub¶
There is one procedure for each of the workbook objects, worksheet objects, and
range objects. In each of the procedures, one variable can be changed: the
object that will have hyperlinks removed. By default, all three will use the
active object.
Applying SUM / COUNT by Color
The built-in SUMIF and COUNTIF worksheet functions act on cells that meet
a condition. Ordinarily, the background color cannot be used as a condition.
This procedure allows such an action.
Example file:
Scenario: There are situations when certain fields ought to
be emphasized—such as an 'Urgent' field. Colors are often
used to show the information for each record: Red = Very
Urgent; Yellow = Be on Guard; Green = Ok.
The problem is that there is no easy way to interact with this
data, such as how to count how many are urgent, or how to
count the dollar values of past-due orders that are marked
Urgent (red).
Search JabSto ::

Custom Search