Results 1 to 3 of 3

Macro that can search for today's date across sheets

Threaded View

  1. #1
    Registered User
    Join Date
    08-21-2012
    Location
    Grimsby
    MS-Off Ver
    Excel 2007
    Posts
    10

    Macro that can search for today's date across sheets

    Hi

    I have a calender type set up where I am using a different sheet for each month. On the front sheet I want a button where I can click and it will take me straight to todays date.

    I have this from a previous thread to find the date on a single page, but how do i modify it to search many sheets?

    Sub Select_Today()
        Dim rng As Range
        Set rng = Range("1:1").Find(Date, , xlValues, xlWhole)
        If Not rng Is Nothing Then
            rng.Select
        Else
            MsgBox "Cannot locate today's date in row 1.", , "Today Never Happened"
        End If
    End Sub
    Thank you
    Last edited by JBeaucaire; 08-21-2012 at 11:20 AM. Reason: Added code tags, as per forum rules. Don't forget!

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1