I have a very large table in MSAccess that I imported into my Excel data model. Now I want to write the code to look up some values in the table to put it on a userform. I have written code to get values from tables in Excel, for example:
How do I reference and activate the table in the data model?
Code:
Worksheets("ProjectPlans").Activate
With ActiveSheet.Range("A:A")
.Find(.....
How do I reference and activate the table in the data model?