I need a va code to find all the -9 and replace them with a blank cell. Each set of data is for one day and there is a total of 13 days. the second photo shows the data for 1 day and the second photo shows how the days are broken up.

(a) The dataset uses the number -9 to represent locations with no data. Write a VBA macro that loops over all the cells of the maps. If a -9 is discovered in a given cell, replace the number with an empty cell. (a) The dataset uses the number -9 to represent locations with no data. Write a VBA macro that loops over all the cells of the maps. If a -9 is discovered in a given cell, replace the number with an empty cell