Shorten VBA code

Hi,

I have two sheets... on first one there is drop-down menu with YES/NO and on the second I have hidden rows. If user select YES on first, row (with specific number.) un-hide on second sheet. NO or "" (empty) hide row. What I made works, but already when putting together I said that I'll ask you, for some other solution due to personal learning. But, always that but, now that I want to add solution to other column on a fist sheet I got error message that code is to long (Procedure too Large Error). So... part of mine code...

Please Login or Register  to view this content.

As you can see 7 lines are repeating from row 39 to 118. At the moment just in D column, but needed also in E column. I believe that there can be done some "loop" or "for" or I don't know what... but... any ideas?

Thx and wish you all the best in 2018!


Cheers, Marko

It looks to be just 18 rows below your target.row, I also assume that sheets("xxx") is not the sheet with the code.

Please Login or Register  to view this content.

... sometimes I feel so stupid! :-(

Thx for this... works perfect. And yes, simple and the best solution.

Cheers, Marko