Results 1 to 4 of 4

Find and activate first cell on currrent row containing...

Threaded View

jeppenedved Find and activate first cell... 02-21-2019, 06:54 AM
kev_ Re: Find and activate first... 02-21-2019, 07:40 AM
mehmetcik Re: Find and activate first... 02-21-2019, 07:44 AM
jeppenedved Re: Find and activate first... 02-21-2019, 08:56 AM
  1. #1
    Registered User
    Join Date
    06-04-2014
    Posts
    34

    Find and activate first cell on currrent row containing...

    Hi!
    I have a a specific value in column D, and the same valuein columns AI to CU. I want a button on every row, to find and select the first cell between AI and Cu, on the row the button is placed, that contain the same value as in column D. How would that macro look like? Thanks!

    EDIT: Perhaps I should have mentioned that the value in the columns between AI and CU is returned by a formula more or less copying the value from column D.
    Last edited by jeppenedved; 02-21-2019 at 07:04 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find value from cell reference in a list and activate cell where found
    By Albert Toet in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-25-2019, 10:55 PM
  2. adding a % value to a currrent formula from another cell
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-05-2018, 03:36 AM
  3. [SOLVED] Find and activate cell via userform
    By GSTVBA in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-18-2017, 04:15 AM
  4. VBA Code to activate cell if text is found in cell, if not find next value
    By snelson0713 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-01-2013, 11:31 AM
  5. [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
  6. [SOLVED] 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
  7. Find a cell with a special value and activate it
    By Mirja in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2005, 09:06 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