View Single Post
Old 01-14-2009, 11:06 AM   #61 (permalink)
Beno999
All Star Reserve
 
Beno999's Avatar
 
Join Date: Nov 2008
Location: Nottingham, UK
Posts: 534
Thanks: 4
Thanked 11x in 9 posts
Quote:
Originally Posted by jade_00 View Post
Ok.

Normally this error refers to a dll issue / compatibility. I MAY be able to fix it so it worked for you, but I would have to know the exact line in the code where the issue is occuring - without having your PC in front of me I can't do that.

I would suggest trying the following.

Instead of pressing the button that says 'Add Fighter', actually go into your Macro menu and run the macro manually - it is possible that the interface button itself is not compatible.

If this doesn't work, if you know how, take a screenshot of the VBA code indicating the line where the code falls down - that would give me a hint as to why.

Hope that helps.

The specific line of code for this error is:

ActiveWorkbook.Worksheets("Pool").Sort.SortFields. Clear

I myself got the exact same error he speaks of.
__________________

Beno999 is offline   Reply With Quote