+ Reply to Thread
Results 1 to 2 of 2

Fix My Code Please - Find in VBA

  1. #1
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Minnesota
    MS-Off Ver
    Office 365
    Posts
    163

    Fix My Code Please - Find in VBA

    What is wrong with my code? It's getting hung up on the find portion of the code, and I'm not sure why. The error is "Object variable or with block variable not set", but I'm not using "with", and the thought the "Cells" was the object.

    I want it to find the number I put into the input box, then put an "x" in the cell to the right.

    Please Login or Register  to view this content.
    Last edited by OpieWinston; 01-03-2018 at 05:07 PM. Reason: Solved it

  2. #2
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Minnesota
    MS-Off Ver
    Office 365
    Posts
    163

    Re: Fix My Code Please - Find in VBA

    Figured it out - the code works fine, but that error is what I get when it doesn't find the number I told it to look for.

+ 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. VBA code to find the code in both Payer and receiver and do concontate
    By julielara in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-04-2016, 01:59 AM
  2. Replies: 6
    Last Post: 02-21-2016, 04:15 AM
  3. Find and Display results VBA Code - Loop to find all Matches
    By i2rule in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-16-2014, 03:14 PM
  4. [SOLVED] How to code the selection.find not to crash when the data to find is blank
    By evertjvr in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-25-2012, 03:04 PM
  5. trouble with vba code for Find, Insert copied cells and find next
    By jgelbach in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-26-2012, 01:45 PM
  6. Put Find code in Loop to find all matches
    By SarahPintal in forum Excel General
    Replies: 4
    Last Post: 02-08-2010, 09:05 PM
  7. code to find, copy and paste until find new, then repeat
    By siddharthariver in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2010, 04:02 PM

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