+ Reply to Thread
Results 1 to 8 of 8

Activate last cell in a column with a given value

  1. 10-23-2018, 09:47 AM #1
    bsrivatsa
    bsrivatsa is offline
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 365
    Posts
    104

    Activate last cell in a column with a given value

    Hi,

    I have a column list with repeating values a,b,c,d,e and f. How to I identify and activate the cell containing, for e.g. the last "e" to do further actions with it ?

    Thanks
    Reply With QuoteRegister To Reply
  2. 10-23-2018, 10:35 AM #2
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Activate last cell in a column with a given value

    Hi,

    Assuming you select your column, this macro will "activitate" the last cell containing "e"

    Please Login or Register  to view this content.
    You might need to adapt according to your file.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
    Reply With QuoteRegister To Reply
  3. 10-23-2018, 10:38 AM #3
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Activate last cell in a column with a given value

    Maybe something like 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 10-23-2018, 01:51 PM #4
    bsrivatsa
    bsrivatsa is offline
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 365
    Posts
    104

    Re: Activate last cell in a column with a given value

    Thanks this works!
    Reply With QuoteRegister To Reply
  5. 10-23-2018, 01:52 PM #5
    bsrivatsa
    bsrivatsa is offline
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 365
    Posts
    104

    Re: Activate last cell in a column with a given value

    Thanks, This works
    Reply With QuoteRegister To Reply
  6. 10-23-2018, 03:02 PM #6
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,077

    Re: Activate last cell in a column with a given value

    Glad we could help & thanks for the feedback
    Reply With QuoteRegister To Reply
  7. 11-07-2018, 05:08 PM #7
    bsrivatsa
    bsrivatsa is offline
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Atlanta, Georgia
    MS-Off Ver
    Office 365
    Posts
    104

    Re: Activate last cell in a column with a given value

    Quote Originally Posted by GC Excel View Post
    Hi,

    Assuming you select your column, this macro will "activitate" the last cell containing "e"

    Please Login or Register  to view this content.
    You might need to adapt according to your file.
    Thanks for this solution.

    Can you also advise how to instruct to look for another letter if the first one isn't in the list? To clarify, if the column doesn't have an "e", how to look for the last "d"?
    Thanks
    Reply With QuoteRegister To Reply
  8. 11-07-2018, 07:36 PM #8
    GC Excel
    GC Excel is offline
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Activate last cell in a column with a given value

    Hi,

    Here's a new code allowing you to search for multiples values in a list until a match is found.
    for example, if "e" is not found, then "d" will be searched.
    if "d" is not found, then "c" will be searched, etc...


    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Runtime error 1004 Activate Method of Worksheet Class Failed - Using Worksheets().Activate
    By webharvest in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-10-2012, 05:10 PM
  2. [SOLVED] Find last row in a worksheet and activate cell in column H
    By LiLi1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-23-2012, 02:20 PM
  3. [SOLVED] Activate macro if you want to change value in a certain column
    By keis386 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 06-11-2012, 08:57 AM
  4. Date Activate Column
    By andrew_net82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2010, 08:48 AM
  5. Search column and activate cell where true
    By iii in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2009, 07:19 PM
  6. How to activate/de-activate a cell based on the selection of a check box
    By kanigelpula in forum Excel General
    Replies: 5
    Last Post: 06-05-2007, 10:06 AM
  7. Activate cell in column B after performing Find
    By excelnut1954 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-06-2006, 02:10 PM
  8. activate macro by values in a column
    By BrianW in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-06-2006, 03:42 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1