VBA to find today's date and hide all other columns in range

[KyleJackMorrison]

Hello,In cells J23:NJ23 I have dates. 01/01/19 - 30/12/19. I require the code to search those cells and select today's date. Once today's date is selected i would like all J23:NJ23 to be hidden apart from the selected cell (today's date).My finished product code would be to select today's date. (E.g. Y23) Copy Y24 - Y130 and paste that into a blank word document. Then copy the word contents to another sheet.After that i need to do the exact same however from today+1 then today+2 etc. All the way up to today + 5.I understand that this is alot. However if i can get just some help on bits and bobs of code i can try and make it work.Many thanks in advance.

 

[KyleJackMorrison]

I apologise, my work computer has deleted all paragraph spaces. And it isn't allowing me to edit this thread. Sorry