How to hide a particular column in excel

Help Activities
, , , , ,
1

I need to hide the particular column in excel

Which has date as 12/31/2020 with out using balarev activity the column will be dynamic

2

can you post screenshot of that excel

3

is “12/31/2020” in 1st row?

4

It will be in any row

5

paste below code in text file e.g. “test.txt”
then use excel application scope with invoke VBA
pass in the following arguments (function = hideColumn , parameters = {“SheetName”}

image
image1217×285 15.1 KB 

Function hideColumn(sheetName As String)
    Dim ws As Worksheet
    Set ws = Sheets(sheetName)
    ws.Activate
    Dim res As Range
    'Cells.Select
    Set res = ws.Cells.Find(What:="12/31/2020", After:=ActiveCell, LookIn:=xlValues, _
        LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False)
    
    Debug.Print res.Address
    Columns(res.Column).Hidden = True
    
    ActiveWorkbook.Save
End Function