User-Defined Type Not Defined

[James_Latimer]

Excel 2010

Hello,
I'm hoping someone can give me a little assistance please.....

I have an xlsm file which seemed to be working fine. I have since recorded a macro for sorting columns descendingly and amended the code putting it into the activate code of one of the sheets.

The code is.....

Private Sub Worksheet_Activate()
    Sheets("D2").Sort.SortFields.Clear
    Sheets("D2").Sort.SortFields.Add Key:=Range("E6:E8"), _
        SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
    With Sheets("D2").Sort
        .SetRange Range("B6:E8")
        .Header = xlNo
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply

    End With
End Sub

The issue i have now is that whenever i type into a cell and hit return i am getting a message "User-defined type not defined". I'm not sure why. I've had a look at other posts and it all seems to be down to references (i cant see any that are missing or unchecked that should be - dont quote me on that!!).

This works fine in excel 2007 though.

If anyone can point me in the right direction it would be much appreciated.

 

[Norie]

Change to Break On All Errors.

 

[James_Latimer]

Done that and the same.

I find the only time i get this error is when using the Return key. If i select a cell, type something into the formula bar and then mouse click onto another cell then the cell is populated and i dont get an error.

Something to do with the return key (somehow).

I'm going to find a dark corner to cry in for a little while

 

[AD_Taylor]

Maybe another thing to consider,

Do you have any Add-Ins Installed? Excel 2007 go to Excel Options and then Add-Ins and Manage Add-Ins. The installed ones are the ones with a tick in on this screen. Excel 2003 I think its under Tools > Macros?

 

[James_Latimer]

MARVELLOUS!!!!!!!!!

Add-ins it is.

All of the add-ins were unticked, i ticked them all and now it works as i'd expect.

Thanks ever so much for helping me out with this. And i apologise if i should have known this solution. As my avatar states............

Thanks again!!

 

[AD_Taylor]

If they were all uninstalled I have no idea how that could have been causing a problem

But if it now works for you thats great I guess!