Do you use Excel 4.0 macro functions?

[Richard Schollar]

Which could be interpreted as not many Guru's are interested in XLM4

Could also be interpreted as hardly any 'gurus' were interested in posting to one of your threads, Baron!

 

[Boller]

Thanks for your feedback Denis.

I can't say that I'm an expert on XLM4 but do occassionally execute functions within my VBA projects.

E.g:

ExecuteExcel4Macro("GET.DOCUMENT(10)")

This will return the number of the last used row, which I find easier than some of the other methods.

Cells(Rows.Count, 6).End(xlUp).Row

I see this method used quite often, but of course this will always consider the last row as per the last item in a list in column F.

Cells.Find (What:="*", After:=[A1], SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row

Whilst this method would return a more TRUE last row but is considerably longer than the XLM4 method.

Regards
Jon

This code :-

ExecuteExcel4Macro("GET.DOCUMENT(10)")

does not do the same thing as the other two bits of code you posted.

It locates the last used row, while the other two bits of code locate the last row containing data.