Do we also have any specific macro for hiding few selected columns?
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of ashish koul
Sent: 28 September 2013 13:04
To: excel-macros
Subject: Re: $$Excel-Macros$$ how to unhide multiple sheets
select sheets tab with control button and press alt h h
On 28 Sep 2013 13:04, "ashish koul" wrote:
> Sub unhide_specific_worksheets()
>
> Dim abc()
> Dim wk As Worksheet
> Dim i As Integer
> abc = Array("Sheet1", "Sheet2")
>
> For i = LBound(abc) To UBound(abc)
> For Each wk In ThisWo
Sub unhide_specific_worksheets()
Dim abc()
Dim wk As Worksheet
Dim i As Integer
abc = Array("Sheet1", "Sheet2")
For i = LBound(abc) To UBound(abc)
For Each wk In ThisWorkbook.Sheets
If wk.Name = abc(i) Then
wk.Visible = xlSheetVisible
Exit F
Hi Experts,
Is there any way to unhide multiple worksheets at once in excel 2007.
Please share your inputs.
Thanks & Regards,
Prabhu R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.fac
