+ Reply to Thread
Results 1 to 2 of 2

Error in this simple code to output cell content if text is found in certain cells

  1. #1
    Registered User
    Join Date
    07-28-2011
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    5

    Error in this simple code to output cell content if text is found in certain cells

    Greetings, I wrote some code to highlight a whole line if the text inputed by the user in up to 3 textboxes were found in a certain cell of that line. Someone was kind enough to edit the code for me to output a cell's content starting at cell B3 everytime the search is positive for a certain line, instead of highlighting the text.

    However I get a "Next without For" error (I had to translate so this might not be 100% accurate) with the code. It's probably something very simple to fix but my coding skills are non-existent.

    Thanks in advance.


    Please Login or Register  to view this content.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Error in this simple code to output cell content if text is found in certain cell

    In fact, your are missing an ENDIF .
    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)

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