+ Reply to Thread
Results 1 to 3 of 3

Finding the cell address for a Match using the application function

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Finding the cell address for a Match using the application function

    I'm trying to find the cell address for a match however I keep getting a 424 error code and can't for the life of me work out what the problem is.

    Can anyone advise what I'm doing wrong please?

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Re: Finding the cell address for a Match using the application function

    Hmmmm, typical just after I post I have a poignant thought.

    This will give me the row that the match is found on wont it?

    If so it can only give me the row rather than the full address, would I need to do something like the below instead of finding the match address?
    Please Login or Register  to view this content.

  3. #3
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,029

    Re: Finding the cell address for a Match using the application function

    How about
    Please Login or Register  to view this content.

+ 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. Application.InputBox : how to capture the cell address into a variable and then re-use it.
    By martinargimon in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 09-18-2019, 04:56 PM
  2. [SOLVED] Find Hostname and Application from a list of IP address from Merged Cell
    By suchetherrah in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-16-2016, 11:57 AM
  3. Match function in VBA, for finding a cell
    By poorworker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-06-2015, 02:19 PM
  4. [SOLVED] Replacing cell address in a formula with the result of ADDRESS function
    By CMG2 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2014, 02:59 AM
  5. [SOLVED] MATCH function workaround - nesting ADDRESS function?
    By BishBosh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-18-2013, 03:45 AM
  6. Help on Application.worksheet.function.match / evaluate+match
    By vidyuthrajesh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-12-2012, 04:30 PM
  7. Dynamic cell address resolution in visual basic application?
    By John Carter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2006, 11:50 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