+ Reply to Thread
Results 1 to 7 of 7

.Find giving me issues

  1. #1
    Registered User
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2010
    Posts
    70

    .Find giving me issues

    So i am try to find a particular prhase in my sheet there are two but only one with the exact phrase but i can not even debug it i got to work somewhat but then I let excel write it with the recorded now i cant get to work at all here is the current version

    Please Login or Register  to view this content.
    Thanks in advanced

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,574

    Re: .Find giving me issues

    What issue(s) are you having?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2010
    Posts
    70

    Re: .Find giving me issues

    i keep getting error code 13 Type mismatch

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,574

    Re: .Find giving me issues

    The After argument of Find should be a range.

    Where are you trying to search anyway?

  5. #5
    Registered User
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2010
    Posts
    70

    Re: .Find giving me issues

    Column A but is the cell at first is megred all the way to AE

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,574

    Re: .Find giving me issues

    If you want to search column A to find out which row 'vt-7' is in you could try this.
    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    12-10-2013
    Location
    Mississippi, United States
    MS-Off Ver
    2010
    Posts
    70

    Re: .Find giving me issues

    Thanks for the Help i added reputation

+ 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. Extracting data from excel to word. Different versions of MS Word giving issues.
    By aritradey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2014, 09:46 AM
  2. Replies: 3
    Last Post: 11-07-2013, 02:02 AM
  3. [SOLVED] Find and Replace Macro issues
    By Billy Dee in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-26-2012, 11:47 AM
  4. Find Info code giving object failed error
    By Leah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-09-2009, 04:24 PM
  5. [SOLVED] help! user form issues; can't find subroutines; appearance issue
    By in-over-his-head-bill in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-06-2006, 05:30 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