Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count function question
I am using the following code to count the values in column B but want to place the total in bold font in another column. How can I do this please? For Each myArea In Range("B:B").SpecialCells(xlCellTypeConstants).Are as With myArea.Cells(myArea.Cells.Count + 1) .Formula = "=Count(" & myArea.Address & ")" .Font.Bold = True End With Next myArea |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count function question
Sub wehd()
For Each myArea In Range("B:B").SpecialCells(xlCellTypeConstants).Are as With myArea.Cells(myArea.Cells.Count).Offset(1, 1) .Formula = "=Count(" & myArea.Address & ")" .Font.Bold = True End With Next myArea End Sub "Alan M" wrote: I am using the following code to count the values in column B but want to place the total in bold font in another column. How can I do this please? For Each myArea In Range("B:B").SpecialCells(xlCellTypeConstants).Are as With myArea.Cells(myArea.Cells.Count + 1) .Formula = "=Count(" & myArea.Address & ")" .Font.Bold = True End With Next myArea |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT QUESTION | Excel Discussion (Misc queries) | |||
Day Count Question | Excel Discussion (Misc queries) | |||
A question about the Count/CountIf function | Excel Worksheet Functions | |||
{=COUNT(IF(etc))} question | Excel Discussion (Misc queries) | |||
Count function question | Excel Worksheet Functions |