Hi,
In a function I receive the range of cells as type range, now before using
it I want to count the number of cells in the range. please indicate how I do
this since I am unable to find a solution.
Kind regards

George

Hi George,

Range("A1:A25").cells.count

or

dim r as range
r = ...some range operation
debug.print r.cells.count

HTH,
Bernd

Thak you

Better, if you receive the range as an argument (which you should):

a.Cells.Count (if a was the range)

Never access worksheet cells directly in a function, always supply them as
an argument

--
Kind regards,

Niek Otten

wrote in message
oups.com...
Hi George,

Range("A1:A25").cells.count

or

dim r as range
r = ...some range operation
debug.print r.cells.count

HTH,
Bernd

Appreciated.

George