how do I find out how many name i have in a list of names

  • Thread starter Thread starter Guest
  • Start date Start date
=COUNTA(A1:A20)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
any help would be great

Thanks

S
Click to expand...

If you mean "Names" like Excel means "Names" (e.g. under
Insert>Names>Define)

here is an algorithm which illustrates how to iterate over the
collection of Excel Names:

Sub Count_Names()
Dim xName As Variant
Dim Result As Variant
Dim iCount As Integer
Dim List As Variant
iCount = 0
' Loop once for each name in the workbook.
For Each xName In ActiveWorkbook.Names
iCount = iCount + 1
List = List + " " & iCount & ") " & xName.Name & Chr(10)
' Loop to the next name.
Next xName
Result = MsgBox(prompt:="There are " & iCount & " Names in the
Active Workbook" & Chr(10) & List, Buttons:=vbOK)
End Sub
 
Back
Top