Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
count non bolded items
Is it possible to write a macro on the above subject line .. and insert
blank row in A1 so as to put in the result? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
count non bolded items
Annette,
Here is one way. Dim i As Long Dim cLastRow As Long Dim cNonBold As Long cLastRow = Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To cLastRow If Not Cells(i, "A").Font.Bold Then cNonBold = cNonBold + 1 End If Next i Range("A1").EntireRow.Insert Range("A1").Value = "Num non-bold cells = " & cNonBold -- HTH RP (remove nothere from the email address if mailing direct) "Annette" wrote in message ... Is it possible to write a macro on the above subject line .. and insert blank row in A1 so as to put in the result? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
count non bolded items
This is just too clever ... thank you!
"Bob Phillips" wrote in message ... Annette, Here is one way. Dim i As Long Dim cLastRow As Long Dim cNonBold As Long cLastRow = Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To cLastRow If Not Cells(i, "A").Font.Bold Then cNonBold = cNonBold + 1 End If Next i Range("A1").EntireRow.Insert Range("A1").Value = "Num non-bold cells = " & cNonBold -- HTH RP (remove nothere from the email address if mailing direct) "Annette" wrote in message ... Is it possible to write a macro on the above subject line .. and insert blank row in A1 so as to put in the result? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
Formula to Add only the BOLDED numbers in a column. | Excel Discussion (Misc queries) | |||
Bolded Text To Column | Excel Worksheet Functions | |||
the sum of all bolded numbers | Excel Worksheet Functions | |||
how to sort list, bolded items from no bolded? | Excel Discussion (Misc queries) |