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!!
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!!
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
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
Happy Automation
Best Regards
Er Pratik Wavhal
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.