Excel vba, find max value in a table column

I have a table named "Table1". In this table I have a column with the name "Idnumber" in the table header. How can I find the highest value in this column and assign this to my variable called "intMaxVal"?

Appreciate ny tips and hints.
hallpettAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

pls try
intMaxVal = WorksheetFunction.Max(Range("Table1[IdNumber]"))

Open in new window

Regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.