Locate Today's Date Within Row on Opening Workbook

Hi there, I've scoured the internet for a few days now trying to find a resolution to my problem but I can't find one that works to fit my specific needs.

I have a workbook displaying the labour distribution of our company, it has dates along the top (within row 6) which is forecast for a number of years into the future (ie, no specific end date as will be extended over time) and a list of personnell down the left side (column C). What I wish to do it when opening the worksheet (tab named 'Workload') I need the active cell to be on that day's date within row 6.

I have found numerous bits of VBA code that locates the date within a column but unfortunately cannot find anything that works to locate the current date within a row.

Really hope you can help and many thanks in advance!

Liam

Hi,

Try this:

Please Login or Register  to view this content.

Dom

Please Login or Register  to view this content.

But for your purpose I think this will be better:

Please Login or Register  to view this content.

Please use the last amended code in the Thisworkbook module.

Please post a sample workbook; if the dates have not been inserted/formatted as 'date' the code won't work.(or better: your data don't....)

cfr. the attachment