Hide column

How to Hide the columns which are red in color

In the C row, what are the columns which are red need to be hided

Help with VBA code or any other method which works!!

@Sweety_Girl
have a look on this custom library:

it has a hideUnhide activity

2 Likes

Yeah… I am quite familiar with this activity…

The only thing here is we need to fed the column or row we need to hide…

Before, I am facing difficulties in obtaining the columns which are red in color

Same hiding the rows which are red … which I am done…
Unable to process same in column … facing issues in looping columns like ex: AA, AB etc

Do u have any idea ?

@Sweety_Girl
in my dark memory somewhere in the forum was a post about returning color & cell range info for a particular range. Just do a quick search. otherwise I would check/google research on how it can be done with invoke vba

2 Likes

Hi @Sweety_Girl

In the below thread i have mention the logic for the same for looping columns like eg AA, AB… etc and so on

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like

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