I found the following macro in another thread:
assuming everything is apples to apples, how do you change "For a = 15 To 1 Step -1" to check all columns and not a specified amount?![]()
Please Login or Register to view this content.
In other words one spreadsheet might have 15 columns whereas another might have 220.
Thanks!
Bookmarks