Results 1 to 3 of 3

Get the address of a selection of cells

This is a discussion on Get the address of a selection of cells within the Excel Questions forums, part of the Question Forums category; I need to get the address of a group of cells instead of just the first cell so that I ...

  1. Mar 18th, 2004, 09:43 PM #1
    Mike E Golding
    Mike E Golding is offline
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike Golding
    Posts
    71

    Default Get the address of a selection of cells

    I need to get the address of a group of cells instead of just the first cell so that I can record the selection and return to it later. Is it possible I ask.
    Thanks for any help. Mike.
    Mikee
    Reply With Quote Reply With Quote
  2. Mar 18th, 2004, 09:46 PM #2
    DRJ
    DRJ is offline
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,856

    Default

    MyRange = Selection.Address
    Excel VBA Training and Certification (Lesson 1 is free)


    -Jacob
    Reply With Quote Reply With Quote
  3. Mar 19th, 2004, 06:11 AM #3
    Mike E Golding
    Mike E Golding is offline
    Board Regular
    Join Date
    Mar 2002
    Location
    Mike Golding
    Posts
    71

    Default Re: Get the address of a selection of cells

    Thanks Jacob. Tought I tried that but in the early hours of the night it's not easy to think straight. Mike
    Mikee
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


DMCA.com