Is there any way to make a hidden column reappear in Excel?

Hi @Kirigirisu_Coin
Or you can use invoke Code

Hide Column.zip (10.4 KB)

excelApp = New Microsoft.Office.Interop.Excel.ApplicationClass
excelWB = excelApp.Workbooks.Open(excelFilePath)
excelWS = CType(excelWB.Worksheets(excelSheet), Microsoft.Office.Interop.Excel.Worksheet)
excelWS.Range(rangeToHide).EntireColumn.Hidden = True
excelWB.Save
excelWB.Close
excelApp.Quit
2 Likes