seamanm125
New Member
- Joined
- Jul 29, 2014
- Messages
- 3
Hi,
I'm trying to create a macro that hides any columns that do not contain any numbers. for example:
<tbody>
</tbody>
Turns to:
<tbody>
</tbody>
I realize that when a number is written alongside text, excel doesn't recognize it as a number. That fine, all I need is a wildcard search for all of my column headings and exclude the ones that don't contain "1" , "2", "3" , "4" , "5".
Any help would be greatly appreciated.
Cheers,
Matt
I'm trying to create a macro that hides any columns that do not contain any numbers. for example:
Cat | dog | mouse 3 | mouse 5 | mouse 4 | Fred |
x | x | ||||
x | x | x | x | ||
x | x | ||||
x | x | x | |||
x | x |
<tbody>
</tbody>
Turns to:
mouse 3 | mouse 5 | mouse 4 |
x | ||
x | x | x |
x | ||
x | x | x |
x |
<tbody>
</tbody>
I realize that when a number is written alongside text, excel doesn't recognize it as a number. That fine, all I need is a wildcard search for all of my column headings and exclude the ones that don't contain "1" , "2", "3" , "4" , "5".
Any help would be greatly appreciated.
Cheers,
Matt