Codeing showes error in 2000 but works in 2007.

**coolhit** · 07-27-2009, 06:46 PM

Hi

Can some assist me, below codeing works fine in excel 2007 BUT doesn't work in excel 2000. I have highlighted in red.

Please Login or Register  to view this content.

Please can someone assist me.

**Phil_V** · 07-27-2009, 07:29 PM

You need to put code tags around your code;
Edit your message.
Click [Go Advanced]
Select your code and click the [Code] button.

**coolhit** · 07-27-2009, 07:46 PM

Originally Posted by Phil_V

You need to put code tags around your code;
Edit your message.
Click [Go Advanced]
Select your code and click the [Code] button.

.

Thanks Phil_V i won't forget next time. Please can someone assist me with my porblem. what is not in excel 2000.

**Leith Ross** · 07-27-2009, 09:08 PM

Hello coolhit,

The last argument SearchFormat doesn't exist in Excel 2000.

Excel 2000 Syntax for the Find Method

expression.Find(What, After, LookIn, LookAt, SearchOrder, SearchDirection, MatchCase, MatchByte)

Re: Codeing showes error in 2000 but works in 2007.