Hiding specific row/column range in a list/array/other

[jonathan9879]

I just started with VBA and am currently struggling to find a solution to this problem:

I understand how hiding works and have code for hiding one range of rows/columns (Worksheets("Sheet3").Columns("A:G").EntireColumn.Hidden = True), but I wanted to be able to store a "list" of column + sheet and a list of rows + sheet. Then run the hiding code in a loop for every range in both lists.

I have no idea even where to start.

 

[My Aswer Is This]

You would need to put a list of sheet names in say Column A of your master sheet
And a list of column numbers or letter in say column B of your master sheet
And a list of row numbers in say column C of your master sheet
Then you could write your script similar to the below one.
This script below is just a sample and will not run.
This gives you an ideal.

Sub Test()
Application.ScreenUpdating = False
Dim i As Integer
Dim Lastrow As Long
Lastrow = Cells(Rows.Count, "A").End(xlUp).Row
For i = 2 To Lastrow
'To hide sheets
Sheets(Cells(i, 1).Value).Visible = False
'To hide row on sheet
Rows(Cells(i, 2).Value).Hidden = True
'To hide row on specific sheet
Sheets(Cells(i, 1).Value).Rows(Cells(i, 2).Value).Hidden = True

Next
Application.ScreenUpdating = True
End Sub