Excel Macro help...

[gjsaturday]

I created a macro in Excel 2002 that some offsite users are trying to use in Excel 2000. I do not have access to Excel 2000 to re-create this macro. Can someone help me.

They are receiving the following error:

run-time error '448':

Named argument not found


Debugging brings them to the following line of code:

Selection.Find(What:="Total", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate


Is there anyway to make this work with Excel 2000?

TIA!

 

[Zathras]

To make it work in Excel 97 I had to remove "SearchFormat:=False"

You might try that (just leave it at the default value).

 

[KenWright]

Zathras nailed it, but just to confirm, removing that argument fixes it in 2000.

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------