Results 1 to 6 of 6

Select the last cell in a column based on the value of another cell

Threaded View

  1. 04-22-2023, 11:52 AM #1
    Andrewstupendo
    Andrewstupendo is offline
    Registered User
    Join Date
    07-20-2015
    Location
    New York
    MS-Off Ver
    2305 - Enterprise 365
    Posts
    147

    Select the last cell in a column based on the value of another cell

    Hello All,
    I would like VBA language that selects the last cell in a column based on the value of another cell that's not in the column. The attached result tab shows that the last cell in column A, A7, was selected based on the value in cell D4.
    If someone could provide coding for this, I would be most appreciative.

    Best,
    Andrewstupendo
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Select a cell based on column and Row search
    By Blacksok in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2023, 07:57 PM
  2. [SOLVED] VBA to select A Range Based on A a fixed cell then the last cell in the Column with Data
    By qwertyyy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-25-2022, 01:02 AM
  3. [SOLVED] Select cell based on value, copy row of select cell and paste into rows in other workbook
    By Ajaxs87 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-04-2022, 12:06 PM
  4. [SOLVED] select entire column based on activecell - multiply cells based if found empty cell
    By k1dr0ck in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 06-08-2016, 01:52 AM
  5. Select cell based on the last entry in other column
    By Kehjz in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2013, 02:44 PM
  6. select column based on cell input
    By jcfrancisco in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 10-04-2011, 09:52 AM
  7. Select a column based on a cell entry
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-29-2005, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1