Forum Discussion

gapag's avatar
gapag
Copper Contributor
Feb 25, 2020

VBA for Applications: CTRL+F does not work, F3 issues out of memory. Fix?

Hi all,

 

Windows 10
MS Excel for Office 365 MSO 16.0.12430.20198 64-bit

 

Using "Microsoft Visual Basic for Applications" to edit an Excel file's macros.

 

The function "find" (Ctrl+f) does not find anything; the dialog just closes, whatever option and string I search for.

 

If I press F3 (Find next) I get the Out of Memory dialog (error 7).

 

Note that

1. the excel's macros run fine

2. Find works on the associated excel file

 

so it seems it is a problem specific to the VBA editor. Any help?

Macros and VBA

2 Replies

  • la-Cour's avatar
    la-Cour
    Copper Contributor
    Mar 08, 2020
    Spoiler
     

    gapag 

    Hi, I am sorry but I don't have a solution to your problem. I experience the exact same. But on a MAC. I have tried to reinstall excel removing a lot of files but the problem is still there. It act exactly as yours. And if I try "Find next" I get at "Out of memory" error. If you have found a solution pleeeease share.

    Regards Christian

    • AJP-2's avatar
      AJP-2
      Copper Contributor
      Jun 03, 2020

      As a work-around I copied and pasted the entire module onto an Excel worksheet and used Excel's Find and Replace to amend text before copying and pasting the revised module back to VBA.

Resources