+ Reply to Thread
Results 1 to 3 of 3

How to select a range within the active column ?

  1. #1
    Registered User
    Join Date
    12-06-2016
    Location
    Paris, France
    MS-Off Ver
    2012
    Posts
    27

    How to select a range within the active column ?

    I am trying to build some code and at some point I need to select cells 120 to 127 within the column that is already active. So, say im in V22, I want VBA to select V120 to 127. If i'm in Z65, I want VBA to select Z120 to 127. Etc

    I can't seem to find how to do this altough it seems quite simple.

    Thanks

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: How to select a range within the active column ?

    Hi,

    You can use Intersect for that
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Registered User
    Join Date
    12-06-2016
    Location
    Paris, France
    MS-Off Ver
    2012
    Posts
    27

    Re: How to select a range within the active column ?

    That worked ! Thank you very much.

+ 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] select column in active row
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-20-2015, 01:10 PM
  2. [SOLVED] How to select general (unspecified) range that is active ?
    By Sachy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-13-2013, 11:59 AM
  3. Select a range from active cell
    By Spagbog in forum Excel General
    Replies: 1
    Last Post: 12-21-2011, 08:17 AM
  4. Select Range in Active Row
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-09-2011, 02:55 AM
  5. Select range from active cell
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-22-2010, 11:42 AM
  6. [SOLVED] How to select range of Active Window
    By Jan in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 05-01-2006, 01:10 AM
  7. In VB macro how do I select range from active cell
    By spydor in forum Excel General
    Replies: 5
    Last Post: 12-29-2005, 07:15 PM

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