Select Multiple Sheets and then Hide Columns

**grimm33184** · 02-04-2013, 11:14 AM

Hi All,

I have a spreadsheet with a collection of 5 tabs.

Sheet 1 is named Summary
Sheet 2 is named Steve's Shop
Sheet 3 is named Joe's Shop
Sheet 4 is named Mary's Shop
Sheet 5 is named Mike's Shop

I want a marco that will highlight only Sheets 2-5 (in this example) Unhide all Columns and Rows then hide columns D-E.

I tried the following:

Please Login or Register  to view this content.

But it only works in the first Tab but not the otheres. What am I missing?

Thanks in advance.

**jeffreybrown** · 02-04-2013, 11:24 AM

How about

Please Login or Register  to view this content.

**RHCPgergo** · 02-04-2013, 11:33 AM

I think you can't do that at once to all the sheets. Try looping through them instead.
Also, you don't need to select the columns to hide/unhide them.

Please Login or Register  to view this content.

**barryleajo** · 02-04-2013, 11:37 AM

With acknowledgements to Jeff and RHCPgergo
another one for the pot

Please Login or Register  to view this content.

**grimm33184** · 02-04-2013, 01:02 PM

Hi Quick Question:
What is the LBound() To UBound(). I am understand the code which is creating the range from 0-3. But not sure how they work.
Thanks

**grimm33184** · 02-04-2013, 01:20 PM

Oh I forgot to ask to add a Scroll up to A1 for each sheet.
I had Application.Goto Reference:=Range("a1"), Scroll:=True
How do I convert it to work with the For - Next function?
Thanks again!

**jeffreybrown** · 02-04-2013, 01:33 PM

Here is at least one place to read about LBound() To UBound().

http://www.cpearson.com/excel/VBAArrays.htm

Please Login or Register  to view this content.

You need to place the qualifier in front of the range so when it loops through the sheets it knows, new sheet...

Notice how it is within the With ws statement and the dot in front of Range("A1") (the dot qualifies the range to each ws)

Hope this help

**RHCPgergo** · 02-04-2013, 04:03 PM

LBound or UBound return the number of the first or last element in the array. (I repeat myself: they don't return the element of the array, but the ordinal number of the element.)

LBound means lower bound and UBound means upper bound (of an array). LBound is usually 1 or 0 and UBound is the number of the last element in the array. Arrays start with element number zero by default.