How do Count how many shapes are on a sheet?

[ypjr]

Hi every1, hope your all well!!

I'm a bit stuck on this one!

U C..I've created a circle called JFC and I want to be able calculate the total number of JFC's on a sheet?

Any help would be most appreciated!!, Thanks & rgds.

Yousuf.J.R.P a.k.a "The Student"

 

[VoG]

This snippet of VBA will count all the shapes on a worksheet

Sub tst()
Dim i As Integer
i = ActiveSheet.Shapes.Count
MsgBox i
End Sub

Is that what you were after?