+ Reply to Thread
Results 1 to 2 of 2

Selection:Active.Cell

  1. #1
    CARLOS BAPTISTA
    Guest

    Selection:Active.Cell

    Please help me. I need to select a range of cells in a row:
    For example:from a5 to j5.
    I want to have "A5" as "active.cell" and write a macro to select from the
    "Active.Cell" to the desired range end.

    Is it possible to use "Offset" or other type of commands.

    Please if anyone can help.

    Kind regards,
    --
    Carlos

  2. #2
    Die_Another_Day
    Guest

    re: Selection:Active.Cell

    Range("A5", Range("A5").End(xltoRight)).Select

    Try that

    HTH

    Die_Another_Day
    CARLOS BAPTISTA wrote:
    > Please help me. I need to select a range of cells in a row:
    > For example:from a5 to j5.
    > I want to have "A5" as "active.cell" and write a macro to select from the
    > "Active.Cell" to the desired range end.
    >
    > Is it possible to use "Offset" or other type of commands.
    >
    > Please if anyone can help.
    >
    > Kind regards,
    > --
    > Carlos



+ 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