Houstons_Time
New Member
- Joined
- Sep 6, 2007
- Messages
- 13
If Target.Count > 11 Then Exit Sub
Dim ThisRow As Long
ThisRow = Target.Row
Sheets("Sheet1").Rows(ThisRow).Hidden = _
Application.WorksheetFunction.CountA(Rows(ThisRow).EntireRow) = 0
I have used your above code and works perfectly fine for one MASTER SHEET - but I am having problem when I try to use this code for TWO MASTER SHEETS.
I have several SLAVE SHEETS and TWO MASTER SHEETS. I have TWO TABLES in each SLAVE SHEET linked TWO MASTER SHEETS indivdually.
I need your help in figuring out a way, where If i edit TABLE 1, it should effect MASTER SHEET 1 (Meaning hide or display rows in Master Sheet).
Is there any way you can tweek this MACRO that you have given for me.
Thanks.
Dim ThisRow As Long
ThisRow = Target.Row
Sheets("Sheet1").Rows(ThisRow).Hidden = _
Application.WorksheetFunction.CountA(Rows(ThisRow).EntireRow) = 0
I have used your above code and works perfectly fine for one MASTER SHEET - but I am having problem when I try to use this code for TWO MASTER SHEETS.
I have several SLAVE SHEETS and TWO MASTER SHEETS. I have TWO TABLES in each SLAVE SHEET linked TWO MASTER SHEETS indivdually.
I need your help in figuring out a way, where If i edit TABLE 1, it should effect MASTER SHEET 1 (Meaning hide or display rows in Master Sheet).
Is there any way you can tweek this MACRO that you have given for me.
Thanks.