=countif(A1:Z26,123)

if some of the cells contain the number 123

or in VBA

msgbox Application.Countif(Range("A1:Z26"),123)

--
Regards,
Tom Ogilvy

"subs" wrote in message
...
How can you count the number of times a specific number is displayed in a
group of cells?