#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
please add example workbook so we know what we are looking at
|
#3
|
|||
|
|||
Apologies @Purfleet, files added now.
|
#4
|
|||
|
|||
Try somthing like this and see if it works
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Title case macro gets a "type mismatch" error at the Instr method | marceepoo | Word VBA | 1 | 03-05-2020 09:41 PM |
Type mismatch error | abenitez77 | Excel Programming | 7 | 04-04-2019 08:51 AM |
Type Mismatch when RibbonX applying crtx to Chart? | Elinor | Excel Programming | 0 | 06-03-2016 06:45 AM |
Name mismatch b/n two columns | hiruy | Excel | 1 | 12-18-2015 07:14 AM |
VBA in Excel: Add a new Word Document on Template (Type Mismatch Error)) | tinfanide | Excel Programming | 1 | 03-29-2012 09:10 AM |