How to find that there are hidden columns in excel sheet and unhide them

Help Studio
, ,
1

I have an excel sheet where there are some columns hidden due to which I am not able to paste the data.
What should I do to find the hidden columns and unhide it?
Can anyone suggest what to do??

2

Hey @Kunal_Jain Check this out

Cheers

1 Like
3

Hi @Kunal_Jain Please check the below thread

4

Hi @Kunal_Jain

Check this

Hope this helps.

5

Should I use it in Invoke VBA??

Sub Unhide_All_Rows_Columns()
    Columns.EntireColumn.Hidden = False
    Rows.EntireRow.Hidden = False
End Sub
6

Yes, @Kunal_Jain is there any difficulty to implement this

7

Please check the below workflow on how to use invoke VBA

SampleProcess.zip (8.6 KB)

8

Invoke VBA: Number of parameters specified does not match the expected number.
I am getting this error

9

There are 2 columns with same name
Due to which error I am getting
Read Range: A column named ‘LG Qty On Hand’ already belongs to this DataTable.
But I need both of them

10

Can you share your sample input excel and VB code

11

Hi @Kunal_Jain ,

Check this below snippet in the market place which can rename the duplicate column names and can get you both the columns,

Hope this might help you :slight_smile:

12

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.