Can any pro tell me about how to make a button that when clicked on,
it will hide those columns without certain Data. As in : Any column
doesn't have data in Row 3, it will hide when clicked the button.

On 1ÔÂ30ÈÕ, ÉÏÎç11ʱ23·Ö, wrote:
Can any pro tell me about how to make a button that when clicked on,
it will hide those columns without certain Data. As in : Any column
doesn't have data in Row 3, it will hide when clicked the button.

haha, how stupid i am! sorry, i solved my problem already, here is the
code:
Sub Column_hide()
Dim r As Variant
For r = 9 To 700
If Cells(r, 71).Value = "0" Then
Rows(r).Hidden = True
End If
Next
End Sub