How to hide a particular column in excel

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

can you post screenshot of that excel

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

It will be in any row

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”}

Function hideColumn(sheetName As String)
    Dim ws As Worksheet
    Set ws = Sheets(sheetName)
    Dim res As Range
    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
End Function