Macro type check columns of multiple tables - return mismatch rows
I have 2 separate macro files with multiple tables in each. Columns for each table are "Name" (String), "Location" (String), "birthdate" (Decimal) except one table has "Age" which I don't need.
I want to loop through all tables. If column contains row with incorrect type, return row number and table.Name. A few tricky dynamic problems in here and not sure where to start.
Last edited by zizz; 08-28-2021 at 02:57 AM.
Reason: Adding errors into Test
|