0

I am running macro-enabled Excel file in one of the server computers in my organization. When I try to use the Find option in VBA developer window, it does not work.

For example, when I use Ctrl+F or Edit -> Find and then try to find a text and click Find Next or Enter, the message box just disappears without going to the next match. Even while selecting current procedure, current module or current project, it is the same. enter image description here

When I select Edit -> Find Next, it gives Out of Memory error. I am not sure if this is related to the issue that the Find command is not working.

This is very strange as the Find command works normally in other computers. What could be the cause and potential fix for this?

Improve this question
6
  • 1
    Seems like a problem with your Office/Excel install - not really a programming question. Commented Mar 6 at 19:38
  • If you quit out of Excel and re-open the workbook, without running any VBA, do you se the same behavior? Does it happen in a brand new workbook with some dummy code? Commented Mar 6 at 22:53
  • Hello. Thank you for the comments! Yes, it's the same even with a brand new macro-enabled workbook. Commented Mar 7 at 8:25
  • I wonder if there is a settings that I need to change or a code that I can add somewhere to fix this. Commented Mar 7 at 9:29
  • Sounds like a problem with your VM or with the Office install. Have your IT folk check it out maybe. Commented Mar 7 at 16:41
Related questions
651
How can I avoid using Select in Excel VBA?
606
Is there a way to crack the password on an Excel VBA Project?
794
How do I find files that do not contain a given string pattern?
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.