Pak please sedikit bersabar ya pak.
Berikut codingnya
Untuk columnnya bisa sdikit dimodif jika hanya ada di row 2,maka bisa diganti jadi range("A2:XFA2") untuk mendapatkan column terakhir sbg trigger
Sub HideMe()
Application.ScreenUpdating = False
lstcolumn = Range("A:XFA").Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
Xdefault = ActiveCell.Address
Range("A1").Select
Dim i
For i = 1 To lstcolumn
If ActiveCell.Value = "" Then
Columns(ActiveCell.Column).Select
Selection.EntireColumn.Hidden = True 'Selection.Delete Shift:=xlToLeft # if you want to delete the column
ActiveCell.Offset(0, 1).Select
Else
ActiveCell.Offset(0, 1).Select
End If
Next i
Range(Xdefault).Select
Application.ScreenUpdating = True
End Sub
Sub ShowMe()
Application.ScreenUpdating = False
lstcolumn = Range("A:XFA").Find("*", SearchOrder:=xlByColumns, SearchDirection:=xlPrevious).Column
Xdefault = ActiveCell.Address
Range("A1").Select
Dim i
For i = 1 To lstcolumn
If ActiveCell.Value = "" Then
Columns(ActiveCell.Column).Select
Selection.EntireColumn.Hidden = False 'Selection.Delete Shift:=xlToLeft # if you want to delete the column
ActiveCell.Offset(0, 1).Select
Else
ActiveCell.Offset(0, 1).Select
End If
Next i
Range(Xdefault).Select
Application.ScreenUpdating = True
End Sub