Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-27-2021, 08:23 PM
zizz zizz is offline Macro type check columns of multiple tables - return mismatch rows Windows 10 Macro type check columns of multiple tables - return mismatch rows Office 2019
Novice
Macro type check columns of multiple tables - return mismatch rows
 
Join Date: Aug 2021
Posts: 2
zizz is on a distinguished road
Default 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.
Attached Files
File Type: xlsm Test2.xlsm (26.8 KB, 1 views)
File Type: xlsm Test.xlsm (29.0 KB, 2 views)

Last edited by zizz; 08-28-2021 at 02:57 AM. Reason: Adding errors into Test
Reply With Quote
  #2  
Old 08-27-2021, 09:53 PM
Purfleet Purfleet is offline Macro type check columns of multiple tables - return mismatch rows Windows 10 Macro type check columns of multiple tables - return mismatch rows Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 335
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

please add example workbook so we know what we are looking at
Reply With Quote
  #3  
Old 08-28-2021, 02:55 AM
zizz zizz is offline Macro type check columns of multiple tables - return mismatch rows Windows 10 Macro type check columns of multiple tables - return mismatch rows Office 2019
Novice
Macro type check columns of multiple tables - return mismatch rows
 
Join Date: Aug 2021
Posts: 2
zizz is on a distinguished road
Default

Apologies @Purfleet, files added now.
Reply With Quote
  #4  
Old 08-28-2021, 09:26 PM
Purfleet Purfleet is offline Macro type check columns of multiple tables - return mismatch rows Windows 10 Macro type check columns of multiple tables - return mismatch rows Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 335
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Try somthing like this and see if it works
Attached Files
File Type: xlsm TEST_AR12.xlsm (30.1 KB, 2 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro type check columns of multiple tables - return mismatch rows 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
Macro type check columns of multiple tables - return mismatch rows 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft