+ Reply to Thread
Results 1 to 2 of 2

Activecell, not for cell,but for range?

  1. #1
    Registered User
    Join Date
    01-05-2006
    Posts
    5

    Question Activecell, not for cell,but for range?

    Is there a way of referring to an active selection of cells in vba, like you can activecell for an individual cell?

  2. #2
    Jim Rech
    Guest

    Re: Activecell, not for cell,but for range?

    You can use Selection when you know nothing else can be selected (like a
    picture). Or ActiveWindow.RangeSelection which should always work (as long
    as there is an active window).

    --
    Jim
    "mturner" <[email protected]> wrote in
    message news:[email protected]...
    |
    | Is there a way of referring to an active selection of cells in vba, like
    | you can activecell for an individual cell?
    |
    |
    | --
    | mturner
    | ------------------------------------------------------------------------
    | mturner's Profile:
    http://www.excelforum.com/member.php...o&userid=30147
    | View this thread: http://www.excelforum.com/showthread...hreadid=504515
    |



+ 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