+ Reply to Thread
Results 1 to 2 of 2

How do you set cursor position at current date in macro?

  1. #1
    Tom Robertson
    Guest

    How do you set cursor position at current date in macro?

    --
    Tom

  2. #2
    Norman Jones
    Guest

    Re: How do you set cursor position at current date in macro?

    Hi Tom,

    Perhaps:

    '=============>>
    Public Sub Tester()
    Dim Sh As Worksheet

    Set Sh = ActiveSheet

    With Sh
    .Cells.Find(What:=Date, _
    After:=.Range("A1"), _
    LookIn:=xlFormulas, _
    LookAt:=xlWhole, _
    SearchOrder:=xlByRows, _
    SearchDirection:=xlNext, _
    MatchCase:=False).Activate
    End With
    End Sub
    '<<=============

    ---
    Regards,
    Norman



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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