Run-time error 438

**bishop7262** · 08-05-2010, 04:10 PM

This is where the error seems to be occuring. thanks for your help.

ActiveWorkbook.Worksheets("Sort Clients").AutoFilter.Sort.SortFields.Clear

**bishop7262** · 08-05-2010, 04:37 PM

Figured I would put down the entire code to see if that might be part of the problem:

Please Login or Register  to view this content.

**romperstomper** · 08-05-2010, 05:09 PM

That code is for 2007 but your profile says 2003. Which are you using?

Note: You must use code tags when posting code; I have added them for you on this occasion, but please make sure to use them in future.

**bishop7262** · 08-06-2010, 05:59 AM

I am actually using 2007 to create the excel sheet but all the computers that it will be used on has 2003. I do I correct this moving forward if my only way of working on this is through my laptop which has 2007?

thank you

**bishop7262** · 08-09-2010, 07:00 AM

Sorry about that. Thank you. But how would I modify recorded macros if I am using 2007 and the other computers are office 2003?

**romperstomper** · 08-09-2010, 07:12 AM

Ideally, you would get your laptop upgraded to 2003 so that you can develop in the same system your users have. Otherwise, your work life is going to get quite annoying!