Getting compile error variable not define

**mso3** · 05-29-2015, 10:02 AM

Hi friends,

I’m getting compile error ‘variable not define’ in the following code.
If the surname is found then I want a first congratulation message.
If the surname is not found then I want a second ‘sorry’ message.

If I delete ‘option explicit’ then the code works fine but if the surname is found then it gives a ‘sorry’ message instead of ‘congratulation’ message.

Please Login or Register  to view this content.

Any help will be highly appreciated.

Thanking you in anticipation.

**stnkynts** · 05-29-2015, 10:19 AM

"found" is a variable which has neither been declared nor defined. In addition, you are using it as a parameter for an if statement which given the lack of definition will always be false; hence the second message box. Give more specifics including an example workbook for new code.

**mso3** · 05-29-2015, 11:53 AM

I'm getting error on 'autofilter' variable not define.

Please see the attached workbook.

Thanking you,

**nilem** · 05-29-2015, 12:09 PM

maybe so (if we use the the proposed approach)

Please Login or Register  to view this content.

**mso3** · 05-29-2015, 12:39 PM

Hi Nilem,
Perfect! It's working fine.

Please explain me the following line because I didn't understand it.

If .Columns(1).SpecialCells(2).SpecialCells(12).Count > 1 Then

Thank you for your cooperation and solution.

**mso3** · 05-29-2015, 08:41 PM

Hello Nilem,
My database contains 5000 rows. After inserting and running the macro I have a compile error 6 over flow on the following line.

Please Login or Register  to view this content.

Solution please!

Thanking you,

**stnkynts** · 05-29-2015, 10:56 PM

Change the .Columns(1) to .Columns(5). See if that solves your problem.

**nilem** · 05-29-2015, 11:34 PM

Hi mso3,
I think this option is better

Please Login or Register  to view this content.

**mso3** · 05-30-2015, 08:03 AM

Hi stnkynts and Nilem,

Thank you to both of you. Both the solutions are working fine.

Thank you for solving the problem.

Getting compile error variable not define

LinkBack

Thread Tools

Rate This Thread

Display

Getting compile error variable not define

Re: Getting compile error variable not define

Re: Getting compile error variable not define

Re: Getting compile error variable not define

Re: Getting compile error variable not define

Re: Getting compile error variable not define

Re: Getting compile error variable not define

Re: Getting compile error variable not define

Re: Getting compile error variable not define

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Getting compile error variable not define

[SOLVED] Getting compile error 'sub or function not define'

[SOLVED] Getting compile error sub or function not define

[SOLVED] Compile Error 'Sub or Function is not define' error on Private Sub Getdata()

Getting compile error sub or function not define

Bookmarks

Bookmarks

Posting Permissions