Hi All

Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

Post Spam and you Will Be Deleted as a User

Hui...
When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

I need a macro to hide column which is contain Particular text like "syed".

Thread starter Syedali
Start date Jan 22, 2019

Syedali

Active Member

Jan 22, 2019

#1

Hi Friends,

I need a macro to hide column which is contain Particular text like "syed".

Attached file for reference.

p45cal

Well-Known Member

Jan 22, 2019

#2

Code:

Sub Macro1()
For Each cll In Range("A5:G5").Cells
  If InStr(cll.Value, "syed") > 0 Then cll.EntireColumn.Hidden = True
Next cll
End Sub

You must log in or register to reply here.

Share:

Facebook Twitter Reddit Pinterest Tumblr WhatsApp Email Link

Top