how to find lastrow when rows hidden.

[chronjy]

There are data range of a1:a10 and a7:a10 is hidden.

Please Login or Register  to view this content.

i want get the number 10, that is really last row.
how can i get this?

there's an alternative
ActiveSheet.UsedRange.Columns(1).Rows.Count

another way?

[sintek]

Perhaps...

Please Login or Register  to view this content.

[Artik]

sintek,Please note that Find starts the search from the next cell after the "base" cell. Therefore, the more correct code would be:

Please Login or Register  to view this content.

Likewise, when you are looking for the first occurrence:

Please Login or Register  to view this content.

Artik

[sintek]

Thanks for clarification Artik...

[chronjy]

thank you very much sintek & artik.