Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the #of ISTEXT cells
Could you help me with the VB code that would perform the following?
Count the number of cells that have text in a range that goes from the active cell to .End(xlRight) Thank you! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the #of ISTEXT cells
Filo - give this a try. It counts the total number of cells and then
subtracts the number of cells that contain numbers. Sub CountText() Dim Count As Integer Count = Range(ActiveCell, ActiveCell.End(xlToRight)).Cells.Count Count = Count - WorksheetFunction.Count(Range(ActiveCell, ActiveCell.End(xlToRight))) MsgBox "There are " & Count & " cells containing text." End Sub -Cory "Filo" wrote: Could you help me with the VB code that would perform the following? Count the number of cells that have text in a range that goes from the active cell to .End(xlRight) Thank you! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count the #of ISTEXT cells
It worked. Thank you!
"Cory" wrote: Filo - give this a try. It counts the total number of cells and then subtracts the number of cells that contain numbers. Sub CountText() Dim Count As Integer Count = Range(ActiveCell, ActiveCell.End(xlToRight)).Cells.Count Count = Count - WorksheetFunction.Count(Range(ActiveCell, ActiveCell.End(xlToRight))) MsgBox "There are " & Count & " cells containing text." End Sub -Cory "Filo" wrote: Could you help me with the VB code that would perform the following? Count the number of cells that have text in a range that goes from the active cell to .End(xlRight) Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I use istext with a sum formula? | New Users to Excel | |||
Sumproduct and ISTEXT? | Excel Worksheet Functions | |||
Blank cells: ISBLANK = FALSE, ISTEXT = TRUE | Excel Worksheet Functions | |||
IsText VBA Error | Excel Programming | |||
ISTEXT | Excel Discussion (Misc queries) |