Deleting (or unhiding) hidden rows in 100+ worksheets (tabs)

**sirgeo** · 03-28-2011, 08:43 AM

Using Excel 2003

Trying to use a macro to output an index for an xls file with 109 tabs (worksheets) but there are 2 hidden columns that i need to either delete or unhide, preferably all at the same time.
What is the tool for this? Thanks!

Screen shot here: http://i.imgur.com/ejDNh.jpg

**MarvinP** · 03-28-2011, 09:43 AM

Hi sirgeo

This code put in a module and run will unhide all sheets columns B and/or C or Both.

Please Login or Register  to view this content.

**sirgeo** · 03-28-2011, 10:14 AM

Originally Posted by MarvinP

Hi sirgeo

This code put in a module and run will unhide all sheets columns B and/or C or Both.

Please Login or Register  to view this content.

Thanks MarvinP! that works perfect.
Can this macro be modified to delete those first 3 columns (a,b,c) in all of the tabs?

**MarvinP** · 03-28-2011, 10:32 AM

Change to

Please Login or Register  to view this content.

**sirgeo** · 03-28-2011, 12:32 PM

Originally Posted by MarvinP

Change to

Please Login or Register  to view this content.

Thanks Marvin! That does the trick!
Got another macro question? that just up, i'll start another thread if it seems needed.
xls file here http://i.imgur.com/VpO2U.jpg needs to have the Route No and Segment Number extracted from the 211 tabs with a hyphen "-" placed between them ie "0405-01-111.7"
Also attached is a macro which did a similar task on another xls file but keeps giving type mismatch error with this new xls.
Any help would be greatly appreciated!