Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Move cursur to the UsedRange

  1. #1
    Guest

    Default

    I don't know it can do or not ,if Activecell is Range F7 and I move to Range EE101 How Can I make Macro to go back to F7.

  2. #2
    Guest

    Default

    Hi

    Try this

    Set x = ActiveCell
    Range("EE101").Select.
    Range("EE101").Value = 777
    x.Select
    End Sub

    If your active cell is F7 the code will select EE101, insert 777 then return to F7

    Hope this helps
    regards
    Derek

  3. #3
    Guest

    Default

    Yes!!!!! Like that What I want, Big Thanks.....Guy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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