Hide Columns based on Date

Hi all,

Thanks for taking the time to read this.

I posted previously with a similar macro hiding columns based on cell values.

I am trying to take it further by changing the cell values to dates rather than integers but am falling a bit short on my modifications to the macro. 

The macro should work but hiding columns with row values less than / greater than cells C5 / C6. Cells C5 / C6 are in date format. The row values are in date format.

If either of cells C5 or C6 are blank, the macro does not run by design.

When I run the macro by changing a cell at present everything becomes hidden with no range of dates showing…

The code is below:

Please Login or Register  to view this content.

Can anyone please help? It would be very much appreciated!

Kind regards,

Coeus.

hi Coeus, change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

Hi watersev,

That worked a treat! Really appreciate it.

Would you mind explaining to me where I was going wrong? Though I can see the difference unsure how it actually has corrected it!


Many thanks,

Coeus.

IsDate returns True or False, you can not compare that to a date and get correct result

Many thanks for your fast replies.

I have had one issue but created a work around - perhaps you might have a better answer?

The dates ranges in the columns is contained within a table. When the macro runs it does not gide any dates < the start date.

When I change the range of i to dates not contained in tables it runs with no issues!

Perhaps something to do with the table storing headers as text?


Again many thanks for your help learning alot.


Regards,


Coeus.

my option

Please Login or Register  to view this content.