Strange Excel Behaviour after Update

[GeekBlueNose]

this is weird..

My laptop just had a major update from Windows.. Took ages to update ever since then the Excel Macro Recorders been playing up..

This is the code it throws up when I try and remove borders and remove any fill colours..

Please Login or Register  to view this content.

I've never seen some of that code before.. what even is .index????

[GeekBlueNose]

Forgot to mentoon quite a few lines are already coloured red for an error on tyhe line and the sub doesn't run...

[GeekBlueNose]

Bump.. Anyone,

[davsth]

what lines are red? You have not included the whole piece of code or a sample workbook, it is hard for anyone to give you an answer. IF it is code further up that is causing a problem lower down how would we know?

[GeekBlueNose]

Please Login or Register  to view this content.

This is the exact code that gets thrown up when I delete rows and record it..

The second line :=xlup is red and throwing an error..

Everytime I record macros the code is not working..

[GeekBlueNose]

I'm bumping this because it's really getting on my nerves.. I've googled it with no luck..

If I was to record a macro now to advance filter a table via variable criteria this is what I get..

Please Login or Register  to view this content.

It makes no sense.. There are even some random capital I's thrown in their for good measure..

Any help would be appreciated..

[rorya]

That code is absolute garbage. I'd suggest a full repair (not the quick one) and if that doesn't work, a full uninstall and reinstall of Office.