Scroll to date for all worksheets

  • I have this vba code which scrolls across a date range to the date entered in cell E4 from column K and returns to column K when E4 is blank



    Now it works fine when applied in Worsheet 1 but not when applied to work sheet 2 as well


    How do I apply this code to all worksheets in a single workbook? I have 3 worksheets in my workbook.


    Many thanks

  • Code Tags
    Your post does not comply with our Forum RULES. Use code tags around code.


    Posting code between

    Code

    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.


    Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. Please take a minute to read the few rules you agreed to when you joined.


    (This thread should receive no further responses until this moderation request is fulfilled)

  • Thank you for checking for me. I have discovered why I couldn't get mine to work. The date is displayed as DAY only but the actual date behind it was incorrect!


    Never rely on someone elses understanding of excel!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!