+ Reply to Thread
Results 1 to 7 of 7

Select Sheet with changing name/date

  1. 12-03-2013, 05:52 PM #1
    frank35
    frank35 is offline
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Select Sheet with changing name/date

    'I have a sheet that is changing its date every day. The format of the sheet for today is 12.3 tomorrow is 12.4 and so on ... The sheet with the changing name needs to be selected for today's date
    Please Login or Register  to view this content.
    Last edited by frank35; 12-06-2013 at 04:23 PM.
    Reply With QuoteRegister To Reply
  2. 12-03-2013, 06:02 PM #2
    Solus Rankin
    Solus Rankin is offline
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Select Sheet with changing name/date

    Declare in by index number.

    Please Login or Register  to view this content.
    You can find this info by selecting the sheet and running 
    Please Login or Register  to view this content.

    e/ Note - this will only work if the name of the sheet changes but its position in the workbook does not.
    Thanks,
    Solus


    Please remember the following:

    1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
    Highlight the code in your post and press the # button in the toolbar.
    2. Show appreciation to those who have helped you by clicking below their posts.
    3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.

    "Slow is smooth, smooth is fast."
    Reply With QuoteRegister To Reply
  3. 12-04-2013, 02:25 PM #3
    frank35
    frank35 is offline
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Select Sheet with changing name/date

    Is it possible to select the sheet that is to the very right of the Workbook?
    Reply With QuoteRegister To Reply
  4. 12-04-2013, 02:58 PM #4
    Solus Rankin
    Solus Rankin is offline
    Forum Expert Solus Rankin's Avatar
    Join Date
    05-24-2013
    Location
    Hollywood, CA
    MS-Off Ver
    Win7 Office 2010 VS Express 2012
    Posts
    2,655

    Re: Select Sheet with changing name/date 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 12-04-2013, 03:07 PM #5
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,197

    Re: Select Sheet with changing name/date

    Hi, frank35,

    Please Login or Register  to view this content.
    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
  6. 12-06-2013, 04:13 PM #6
    frank35
    frank35 is offline
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Select Sheet with changing name/date

    HaHoBe, let me check this auf der Stelle!
    Last edited by frank35; 12-06-2013 at 04:23 PM.
    Reply With QuoteRegister To Reply
  7. 12-06-2013, 04:22 PM #7
    frank35
    frank35 is offline
    Forum Contributor
    Join Date
    10-08-2013
    Location
    End of the World, USA
    MS-Off Ver
    EXCEL 2007
    Posts
    111

    Re: Select Sheet with changing name/date

    HaHoBe is the best, thank you Holger !
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Dynamic chart automatically changing its range if we select wrong date
    By maniknandi in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-06-2013, 12:46 AM
  2. [SOLVED] Changing Multiple sheet names by wk ending date for yr but need specific name/date format
    By kedeling in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-06-2013, 02:40 PM
  3. [SOLVED] Reading a date from another sheet and changing the format
    By cafc_fuller in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-13-2012, 07:34 AM
  4. select date which updates sheet
    By lprenrut in forum Excel General
    Replies: 1
    Last Post: 11-30-2011, 06:51 PM
  5. [SOLVED] Changing a sheet name to the current date
    By Reddist in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2006, 03:40 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1