Excel VBA code to change #N/A to 0 in set ranges does not work. Workbook has a sheet for each day to the month, a button on each that runs macro to get data from a database PI System, based on the date on the sheet. Formula's are set up to pull the data for each hour. Trouble is when there is no data, like when the time changes to DST there is no 24th hour, it inserts error #N/A. Other macro's insert this gathered data at other locations on the sheet, thus #N/A's are carried over. I want to change those #N/A's to 0. My code is supposed to change only those #N/A's, which is set ranges, to values first, then replace them with 0. I don't need to change the first location this data enters the sheet. I have tried different ways & it still doesn't work.

Part of my latest ChangeErrors() Sub is:
Range("C12:Z13").Copy
Range("C12:Z13").PasteSpecial Paste:=xlPasteValues
Range("C12:Z13").Replace What:="#N/A", Replacement:="0"

I have searched the questions that others have asked and found nothing that might help. Please, any suggestions?