CurrentRegion question

[zev]

A one-line function program:

MyCount=Range("A1").currentregion.rows.count

gives 8,061 (the correct answer) when run from a testing subroutine but returns "1" from any cell on the worksheet.

What am I misunderstanding?

Zev

 

[dforgacs]

Hi,
I think when you use currentregion, once it sees an empty cell in the data it stop counting.
Try this
Mycount = Cells.Find(What:="*", SearchOrder:xlByRows, SearchDirection:xlPrevious).row

dforgacs

 

[pgc01]

Hi zev

A UDF (a vba function called from a worksheet in a formula) has may limitations, one of them is that you cannot use the CurrentRegion property.