Find a certain cell that contains today's date and select the cell and its sheet.

[tyeinse]

I have made the macro that does as ,soon as i open the file, select today's date but only if date is in sheet5... sheet 5 is may so it works. Can someone help me doing the same job for every sheet in the file

Please Login or Register  to view this content.

[Fotis1991]

Did you tried to replace your sheet name with ActiveSheet?

[tyeinse]

No unfortunately it is not working at all with activesheet

[Fotis1991]

Can you pls upload a small sample workbook?

[Fotis1991]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[tyeinse]

sample.xlsx


That is a sample file of what i want to do

[tyeinse]

Now i want when i open the file the sheet contains the date we have today to be open and the current today date year etc to be selected

[Fotis1991]

This code works in the Active worksheet

Please Login or Register  to view this content.

[tyeinse]

Yeah it does, but my code at the start of the post works also for active sheet. My problem is i want when i open excel file to go to todays date and sheet even if i saved the file in another sheet

[berlan]

Alternative:

Please Login or Register  to view this content.

Cheers, berlan

[tyeinse]

thnx for helping guys i think i ve found the solution again below is the code for all sheets :D

Please Login or Register  to view this content.