Showing Details

[oro77]

Hello,

I am using "ExecuteExcel4Macro "SHOW.DETAIL" in order to show or hide details of my cells.
It works well but I need to distinguish the show and hide part.

I have tried using the ShowDetail property :

In my Excel, the 11th row has a group with hidden cells, the code below always goes to True (a = 2)

Please Login or Register  to view this content.

Thank you in advance.

[gjlindn]

Hello oro77, would you be able to upload an example workbook? Thanks!

[oro77]

Yes, of course.

Double click on the L cell, it will show details.
In the debug mode, when I try to detect if the details are shown or not, I get the

[gjlindn]

Hi oro77. I think you want to check columns rather than rows. Try changing to this

Please Login or Register  to view this content.

[oro77]

Thank you so much