+ Reply to Thread
Results 1 to 4 of 4

Setting the range as only those cells selected/ highlighted

  1. #1
    Forum Contributor
    Join Date
    04-19-2013
    Location
    Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    297

    Setting the range as only those cells selected/ highlighted

    Fairly straightforward but how do I set the range as only those cells selected.

    Essentially I want to change some absolute reference some cells.

    I have found this code:

    Please Login or Register  to view this content.
    Just need it to apply to selected cells that

    Thanks in advcance

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Setting the range as only those cells selected/ highlighted

    Maybe:

    Please Login or Register  to view this content.

  3. #3
    Forum Contributor
    Join Date
    04-19-2013
    Location
    Yorkshire, England
    MS-Off Ver
    Excel 2010
    Posts
    297

    Re: Setting the range as only those cells selected/ highlighted

    Cheers dude, thats perfect

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Setting the range as only those cells selected/ highlighted

    Glad to hear it works, and thanks for the feedback.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] HIghlighted range dependent on month selected
    By orozvik in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-18-2013, 01:45 PM
  2. Replies: 11
    Last Post: 07-15-2012, 04:08 PM
  3. Replies: 4
    Last Post: 06-29-2012, 07:22 AM
  4. Setting TAB to navigate to selected Cells Only
    By Corey in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-29-2006, 05:00 AM
  5. [SOLVED] Is there a macro which adds selected/highlighted cells?
    By Ed in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-28-2005, 09:05 AM

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