+ Reply to Thread
Results 1 to 5 of 5

select range in column of active cell

  1. #1
    Registered User
    Join Date
    01-08-2015
    Location
    Australia
    MS-Off Ver
    Mac 2011
    Posts
    75

    select range in column of active cell

    Hi,

    I'm wondering if someone can help me with the VBA code to select a range of cells within the column of the active cell. I'm wanting to select the cells in row 3 to 167 but only within the column of the active cell.

    I hope that makes sense.

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: select range in column of active cell

    Something like
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    04-23-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 365
    Posts
    2,401

    Re: select range in column of active cell

    One more way (although I think I like jindon's first code line best)...
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by Rick Rothstein; 12-31-2021 at 03:05 AM.

  4. #4
    Registered User
    Join Date
    01-08-2015
    Location
    Australia
    MS-Off Ver
    Mac 2011
    Posts
    75

    Re: select range in column of active cell

    Thank you. All options worked. I went with jindon's first option as it is the one i understand the most. The only thing I'm unsure of is the meaning behind the use of 'a' in the range?

  5. #5
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,464

    Re: select range in column of active cell

    There are more ways like
    Please Login or Register  to view this content.
    When you refer a range/cell/column/row Range/cells/column/row plays as reference.
    e.g
    Please Login or Register  to view this content.
    HTH

+ 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 a range from active cell to last non blank row
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2021, 04:31 AM
  2. [SOLVED] How to select a range within the active column ?
    By DaChocapic in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-17-2017, 11:26 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 from active cell
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-22-2010, 11:42 AM
  5. how to auto-select range of active cell
    By panamakevin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2010, 12:46 AM
  6. Select and Copy Range from Active Cell
    By Leah in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-21-2009, 03:23 PM
  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

Tags for this 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1