How to count number of items(cells) in range?
 

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

How to count number of items(cells) in range?
 

Hi George,

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

or

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

HTH,
Bernd

How to count number of items(cells) in range?
 

Thak you

How to count number of items(cells) in range?
 

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

How to count number of items(cells) in range?
 

Appreciated.

George