Remove Formatting Runtime Error 1004

[GreatOffender]

Not the best or brightest using VBA but I've done this a 100 time before but now it's giving me grief. Keep getting runtime 1004 error. This is driving me crazy so any help would be appreciated.

Thanks,

Dim wc As Worksheet   
Set wc = Sheets("ABC")
   
wc.UsedRange.Value = wc.UsedRange.Value

 

[Fluff]

What is the error message?

 

[GreatOffender]

Run-time error '1004'
Application-defined or object-defined error

 

[Fluff]

That I find odd, as there is nothing wrong with the code you have posted.
What line is highlighted when you get the error?
Is the sheet protected?

 

[GreatOffender]

I have the workbook protected but it's always been protected so I'm at a loss. Just simple edit under "Developer" option.

 

[Fluff]

Is the sheet (not workbook) protected?
When you get the error click "Debug", what line of code is highlighted?

 

[GreatOffender]

This is on my end. Nothing runs on my laptop but the macros seem to preform "as advertised" on others. I have an idea where the problem lies (settings) but if someone has something I might be overlooking please shout it out.

 

[Fluff]

Any chance of answering my questions?

 

[GreatOffender]

Sorry I didn't get back sooner but work ended and that's where I leave it, at work.

It dies when it reaches "wc.UsedRange.Value = wc.UsedRange.Value". That's where the error occurs but I seem to be having problems with other "working" macros that seem to run fine on laptops other than my own. Decent quad core chip with 12mb memory running Office 2013 64bit.

 

[Fluff]

If the code works on other computers, then the problem is not with the code.
It might be worth Repairing Office & see if that helps