Open Sheet to Last Used Tab / Range

[@marcusmues]

I've been trying to figure out how to make something like this work for AGES on a budget sheet I keep. This finally solved it - no more clicking through multiple tabs to get to the current month! Thanks very much!

[@SpencerFarris]

Hooray!

[@nicolasrada1325]

Your channel provides so much value, maybe the views are not reflecting but remember that this value is HUGE and affecting peoples work and potentially improving daily work for many Thank you so much for your contribution, you are truly a wonderful human THANK YOU

[@SpencerFarris]

Thank you so much for the kind words! Also, if there are any specific things you'd like shown I'm always looking for more ideas.

[@AdaKetchum]

Hello! Thank you for the helpful video! Is there a way to open to a range when you open a specific tab?

[@SpencerFarris]

No. There is no trackable event for "open sheet"

[@Brakken99]

This is really slick. Is there a way to exclude a tab from this function?

[@SpencerFarris]

Sure! In the onEdit() function add this at the top: if (e.source.getActiveSheet().getName() == "sheet name here") return;

[@Brakken99]

@@SpencerFarris Worked a treat, thanks! So many gems like this are hidden.

[@MatiasParente]

This doesn´t work in 2023, but thanks for the effort!

[@SpencerFarris]

It works just fine. What problem are you having?