In my worksheet the tabs are named by years. When the sheet matching the current year is opened , I'd like the first empty cell in the range F3:F300 to be selected.
For example , if I open tab 2022 , then as it's the current year the first empty cell in the range would be selected. If I open any other tab , say 2020 , then no action is taken. I assume I'll need to place the event code under each tab.
I'm not even sure it's possible , but I'm grateful for any advice.
I've attached a sample file.
Using Excel , Word and Access 2003 - For the whole of 2024
Put this in the ThisWorkbook code module...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Perfect - may thanks. It works first time and exactly solves the issue. I'm impressed!
BTW If I wanted to have say 15 rows empty below the selected blank cell could the code be modified so it scrolls without changing the selected cell?
Last edited by CDandVinyl; 06-11-2022 at 08:15 PM.
Originally Posted by CDandVinyl
Please Login or Register to view this content.
Last edited by AlphaFrog; 06-11-2022 at 09:55 PM.
That's working brilliantly now. Many thanks for your time and expertise.
You're welcome.
I slightly modified the scroll code above at the same time you posted thank you. Make sure you have the latest change.
Yes - I got it. Many thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks