ExcelBanter - Open sheets as per the range

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Open sheets as per the range (https://www.excelbanter.com/excel-programming/425900-open-sheets-per-range.html)

Kashyap

Open sheets as per the range

Col H
ABC
XYZ
MNO
PQR

Hi, I have names in ColH and sheets of these names as well which will be
hidden.. I am try a macro to make all the sheets in this specified range to
be visible.

Assist pls..

Thanks

Jacob Skaria

Open sheets as per the range

Try this code...

If this post helps click Yes
--------------
Jacob Skaria

Dim intRow
intRow = 1
Do While Range("H" & intRow) < ""
ActiveWorkbook.Sheets("" & Range("H" & intRow) & "").Visible = True
intRow = intRow + 1
Loop

All times are GMT +1. The time now is 12:08 PM.