Hiding Columns based on Row Values (continued...)

Hi all,

Hope all is well and you enjoying your long bank holiday weekend!

I'm continuing to evolve a worksheet change macro which I got some previous help from on here:

HTML Code: 

I'd much appreciate any further help to finish this off - learning alot!

I have attached a test workbook and embedded my macro below.

Please Login or Register  to view this content.

The aim of the game is to hide rows not contained with the week ranges in column B - for example if WEEK2 and WEEK4 are select, any columns NOT WEEK2, WEEK3 and WEEK4 should be hidden.

Also if no data is in column B (in either reference cells) no columns should be hidden.


A thanks to Olly and GC Excel for your help in the previous post - if you want to continue helping it would be greatly welcomed!


All the best,


Coeus.

Hiya TMS.

I changed the following and it worked like a charm:

If rInterest(1) = "" And rInterest(2) = "" Then

If rInterest(1) = "" OR rInterest(2) = "" Then


Many thanks for your help!

Reputation added!


Regards,



Coeus.