• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 6740
  • Last Modified:

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.
0
hallpett
Asked:
hallpett
1 Solution
 
Rgonzo1971Commented:
Hi,

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

Open in new window

Regards
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now