Best way to finding max, min, and lookup in ListObject

[radek225]

Hi I have some experience with VBA in MS Access, now I'm starting to learn VBA Excel References. I would like to ask. Assuming I've created List Object from some Range. What is the best way to working with in VBA? I mean how could I found something like in ms access - dmax() dLookup() dmin() dcount() ofc I would like using criteria to working with these functions. - is there something like that in Excel? Is it good habit to creating sql string from list object and then working with dao.recordset with that?

[dflak]

You might find this article handy: http://www.utteraccess.com/wiki/Tables_in_Excel

and then follow it up with https://www.thespreadsheetguru.com/b...t-excel-tables.