get last non-empty row - Excel

[Jfish]

Right, that worked.  Also, getting back to the OP ... this will find the last used cell in a range:

$LastRow = $oWorkbook.ActiveSheet.Range("A1").SpecialCells($xlCellTypeLastCell).Row
MsgBox("","",$LastRow)

The constant for that is also in the UDF.  I think that would also be a great add as a function ,,,

EDIT: Warning this is still a great method but if anyone wants to use this method you must save before calling because .SpecialCells(xlCellTypeLastCell) is only recalculated when the sheet is re-saved.

Edited October 31, 2014 by Jfish

[water]

I think I will add some examples of range selection to the wiki.

[water]

I started with the wiki.

What do you think?

[Jfish]

Water -

I think what you posted on the wiki is very useful.  I agree with the idea of the focus on range selection because that is probably the trickiest part.  From there, users can do all sorts of things.  I would consider adding some simpler examples to compliment the ones you already have.  Select a range with and without variables.  For a default sheet, for a specific named sheet, etc.  I say that because if you knew nothing about it and looked at the examples (which are great) you may learn some of the less intuitive selections but still may not walk away with the practical everyday examples.  Also, consider that the help file does not completely document them either because the complexity is hidden by the functions that do most of those things for the user.

I know this is a bit off topic but it may also be good to document some of the other constants somewhere that are available in the UDF but not part of the help file.  Example from the above thread: $xlCellTypeLastCell.  Since these are already part of the include it would be useful to know some of the things they can do (or maybe they are already documented somewhere?).

[water]

Thanks for the comments.

It's not easy to know where to start and where to end.Adding too much information and examples to the wiki will again leave users unsatisfied.

I think we can expect a little bit of knowledge of Excel and Autoit before a user starts to automate Excel.

To best use my limited spare time I'm going to expand the wiki based on user queries. If the question sounds to be sensible for others too I will add the answer to the wiki.

OTH the wiki is free for everyone to modify