compile error: sub or function not defined

**eaglefana101** · 08-16-2012, 09:31 AM

I am trying to write a macro that will search through a cell that contains the abstract, title, and author keywords of a paper so that I can determine which industry it applies to based on a list of keywords that i have specified. I had orginally written an excel formula for it using ISNUMBER(SEARCH but since I have over 33,000 papers and 24 different industries I am searching for my excel file became to large and my computer was constantly crashing. My Tech guy told me to write a macro that will perform this to stop my computer from crashing. The code I have below only applies to one industry but can someone help me solve my compiling issue as well as fix my code? I have looked at other threads to try to debug my issue and I have checked the Solver box in references but my first line of code is still highlighted in yellow and the error still comes up.

Please Login or Register  to view this content.

Additionally the industry keywords i have created are in a separate worksheet from the worksheet I am trying edit. I don't know if that is not possible or makes a difference in what I'm trying to accomplish. Thanks!

**JapanDave** · 08-16-2012, 09:37 AM

Please put your code in tags,
Either "DoEvents" does not exist or you have mistyped the macro name or function name, or the code below is the problem.

Change the line in your code that = = "aerospace" line needs to be this,

Please Login or Register  to view this content.

**Andy Pope** · 08-16-2012, 09:38 AM

Before resorting to code, have you tried using advanced filtering?

**Cutter** · 08-16-2012, 07:49 PM

@ eaglefana101

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**Alf** · 08-17-2012, 12:27 AM

Before you can use the Solver VBA functions in the Visual Basic Editor, you must establish a reference to the Solver add-in. In the Visual Basic Editor, with a module active, click References on the Tools menu, and then select Solver under Available References. If Solver does not appear under Available References, click Browse, and then open Solver.xlam in the \Program Files\Microsoft Office\Office14\Library\SOLVER subfolder.

Alf

**rylo** · 08-17-2012, 01:18 AM

Hi

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

There is no reference cells(0,2) which the first pass of your loop would try to action.

rylo

compile error: sub or function not defined

LinkBack

Thread Tools

Rate This Thread

Display

compile error: sub or function not defined

Re: compile error: sub or function not defined

Re: compile error: sub or function not defined

Re: compile error: sub or function not defined

Re: compile error: sub or function not defined

Re: compile error: sub or function not defined

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions