Last cell VBA code. Are there limitations?

[gaj104]

Hi,

Curious, is there any limitations of using this as my code to find the last used cell in a sheet?

Cells.Find("*", SearchDirection:=xlPrevious)

i.e the last row would be

Cells.Find("*", SearchDirection:=xlPrevious).Row

Thanks

 

[Richard Schollar]

You may want to specify all the other arguments too to control how the Find works eg if you lookin:=xlValues, then it won't find hidden rows (or filtered out ones) but if you use Lookin:=xlFormulas then it will find even filtered values.

Similarly, SearchOrder is useful to specify whether searching should be by rows or columns - either potentially giving you a substantially different result.

 

[gaj104]

Good to know. I'm updating various coding in excel 2003 sheets (where uses the "A65536".end(xlUP) method, and experimenting with the shortest code I can use.

Thanks Richard