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

 

[GreatOffender]

I found the offending object. All of the cells in the first 3 columns have quotes around the data and I use the "UsedRange.Value" to remove the quotes. I went through the entire sheet of source data and found one cell the listed with a "=" before the data (="data is here"). This was my Waterloo! Once the "=" was removed it all worked as advertised. I use this method of removing values for several spread sheets but this was my first encounter with this oddity. Others using this macro were not using the same source data which made me believe it was localized to just me.


Fluff - Thank you for sticking with this. As a hard headed Irishman I have a problem with walking away.

 

[Fluff]

Glad you sorted it out & thanks for the feedback