Hide Columns Based on Values Referenced from Separate Worksheet

Hello World!

I am designing a template that will create a budget report for projects. The user will open the workbook template and enter in requested data including a start date and end date for their project. The template by default will list months from Jan-13 to Jun-20 (in mmm-yy format) and additional project information on a separate sheet titled TABLE. The date range is entered in by the user on a sheet titled DATERANGE (also in mmm-yy format). The macro I am working on should hide any columns on TABLE sheet with dates outside the entered date range on the DATERANGE sheet.

Here is the code I have so far. It does not work; I do not know how to use Objects:

Please Login or Register  to view this content.

Can the code perform both > and < operations at once?

Any help with this or a point in the right direction to a documented walkthrough would be sincerely appreciated.

I have attached a very simple example of how the workbook will look as I'm sure my description isn't very helpful.
daterange.xlsx

Hi xkittenxx
try it

Please Login or Register  to view this content.

Brilliant Nilem!

Had to tweak the code slightly to include values entered into DATERANGE!B4.

Please Login or Register  to view this content.

Again, many many thanks!