+ Reply to Thread
Results 1 to 6 of 6

Excel VBA Find and Replace Run Time Error 91

  1. 06-30-2015, 02:31 AM #1
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Unhappy Excel VBA Find and Replace Run Time Error 91 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-30-2015, 02:54 AM #2
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Excel VBA Find and Replace Run Time Error 91

    What is wrong with the code?

    That is the least you could mention
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 06-30-2015, 02:57 AM #3
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Excel VBA Find and Replace Run Time Error 91

    Hii,
    I want to find "NA" in range T11:T5010 and replace with nothing "" but getting error....
    Reply With QuoteRegister To Reply
  4. 06-30-2015, 03:04 AM #4
    NeedForExcel
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,873

    Re: Excel VBA Find and Replace Run Time Error 91

    Something like this?

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 06-30-2015, 03:30 AM #5
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Excel VBA Find and Replace Run Time Error 91

    Dont know what happening but it is not working in my original workbook... single Code is working fine if run in new workbook..

    Also I want to avoid further errors if "NA" not found...
    Last edited by mangesh.mehendale; 06-30-2015 at 03:40 AM.
    Reply With QuoteRegister To Reply
  6. 06-30-2015, 04:02 AM #6
    mangesh.mehendale
    mangesh.mehendale is offline
    Valued Forum Contributor mangesh.mehendale's Avatar
    Join Date
    06-04-2015
    Location
    India
    MS-Off Ver
    2007
    Posts
    510

    Re: Excel VBA Find and Replace Run Time Error 91

    okay... got it... It is not working on HIDDEN CELLS in protected workbook.. thanks for reply..
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel VBA Find and Replace Run Time Error 91
    By mangesh.mehendale in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2015, 05:40 AM
  2. Need a macro to find and replace words in word using excel column 1(find) column (replace)
    By ramradha6 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  3. Run Time Error '6' Overflow - Macro That Find Text and Copy Range & Replace on Other Sheet
    By asgharhussaini in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-17-2013, 04:34 AM
  4. Find and replace #REF! Error
    By nickcast22 in forum Excel General
    Replies: 1
    Last Post: 07-19-2012, 05:56 PM
  5. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1