Need help writing VBA code for the following

Write a subroutine that: . Writes a random number between 1 and 100 into the range Al:J10 Reads the values from the worksheet and stores them in a 2 dimensional array of Integer. This must be done after the values are written to the worksheet. Loops through all the values in the array and counts the number of values that are greater than a value specified by the user (use Inputbox and remember to convert the value from a String to an Integer, also use an IE statement to ensure a number between 1 and 100 is entered, inclusive). Display the results in a message box. Loops through all the values in the range A1:J10 and shades all the cells with values larger than the value specified red