+ Reply to Thread
Results 1 to 4 of 4

Matching a cell on Sheet 1 to a cell that exists in column A on sheet 2

  1. #1
    Registered User
    Join Date
    03-22-2017
    Location
    Kitchener, Canada
    MS-Off Ver
    MS Office 2010
    Posts
    10

    Matching a cell on Sheet 1 to a cell that exists in column A on sheet 2

    Hey,

    So I have the code below which I feel may help me solve this problem but I am getting the following error for these two lines:
    Set SearchRng = Legend.Range(Cells(1, 1), Cells(1, LEGRow))
    Set Find = rSearchRng.Find(Cells(subTaskBEG, Name).Value)

    The error is Application -defined or object-defined error.

    Please Login or Register  to view this content.

    Thank you in advance for the help!!
    Last edited by supremenuts; 03-23-2017 at 03:15 PM.

  2. #2
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Matching a cell on Sheet 1 to a cell that exists in column A on sheet 2

    I'm gonna give you a code to find a value in another sheet because your code is rather confusing for me the way you use your variables.

    Let's say you have a value in Range("A1") of Sheet2 and you want to search for it in Column A in Sheet1 (Sheets Legend).

    Please Login or Register  to view this content.
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  3. #3
    Registered User
    Join Date
    03-22-2017
    Location
    Kitchener, Canada
    MS-Off Ver
    MS Office 2010
    Posts
    10

    Re: Matching a cell on Sheet 1 to a cell that exists in column A on sheet 2

    Thank you, worked perfectly!

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MO Prof Plus 2016
    Posts
    6,907

    Re: Matching a cell on Sheet 1 to a cell that exists in column A on sheet 2

    You're welcome and thanks for rep+.

+ 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. Replies: 1
    Last Post: 03-15-2017, 05:01 PM
  2. Replies: 3
    Last Post: 12-10-2015, 02:50 PM
  3. Replies: 2
    Last Post: 11-18-2013, 07:31 AM
  4. Replies: 5
    Last Post: 02-21-2013, 07:17 PM
  5. Copy Row from 1 sheet to another sheet named matching cell value
    By heiny1056 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2012, 04:43 PM
  6. [SOLVED] Return comment to master sheet after matching to source sheet name and cell number
    By jeffreybrown in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-21-2012, 05:09 PM
  7. Find matching cell in other sheet and copy cell from different column
    By level3ninja in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2011, 03:29 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