pedie
Well-known Member
- Joined
- Apr 28, 2010
- Messages
- 3,875
Hi,
I am sure how i should explain this...
I have two codes below. that I want to place in one command button:
when I click if row is "" then hide....the next time i click again no matter what show all the cells irrespective..."" or <> ""
Like pause and play button that does both the thing....
Thanks for HELPING...
Pedie
Please give some idea...thanks again
I am sure how i should explain this...
I have two codes below. that I want to place in one command button:
when I click if row is "" then hide....the next time i click again no matter what show all the cells irrespective..."" or <> ""
Like pause and play button that does both the thing....
Thanks for HELPING...
Pedie
Code:
Option Explicit
Sub test()
'
Dim lstRng As Range
Dim c As Range
Set lstRng = Sheet1.Range("a1", Range("a65536").End(xlUp))
For Each c In lstRng
If c.Value = "" Then
c.EntireRow.Hidden = True
End If
Next c
End Sub
Code:
Code to to unhide all cells
Please give some idea...thanks again