Select entire row without cells E,F

How to select the entire row without cells E:F.
These cells must be unselected because in columns E,F I have ComboBox and after double click i get text zoom.
When I have selected entire row, my ComboBox does not work.
I use it for "highlighting" row in Gantt Chart.

My code is below and I need to help with that.

Please Login or Register  to view this content.

First hide the columns that you don't want to select. Then select SpecialCells(xlCellTypeVisible).

So something like below.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks. That's it.