Selecting a specific cell in a table with VBA

[BAVE]

Hello all,

I'am trying to write a vba code that selects a specific cell in a table. This tables contains dates in column A and names of tanks in row 1. I would like to select the cell that matches the date of today in its row and the name of tank D in row 1. For this I have the following code, that does not work Can anyone help me?

Please Login or Register  to view this content.

[:) Sixthsense :)]

Code like this...

Please Login or Register  to view this content.

If you would like to select based on a range then use like the below.......

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[BAVE]

Thanks! It's working perfectly!

[:) Sixthsense :)]

You're welcome and thanks for the feedback