IN VBE IN EXCEL

Write a function subroutine called MaxRange that mimics Excels MAXfunction. It should accept a range as the input argument and it should return the largest value in that range. Just like the Excels MAX function, it should ignore strings and empty cells, and if the range contains no numbers it should return 0. (For simplicity, assume that we will not test your function with ranges that contain negative numbers, dates, times, or cells with errors.)

In Question3.xlsm, if we enterthe formula -MaxRange (A2:A8) into cell C2, as shown in figure below, we should get 14.1 as the result in cell C2. 12 5.5 string MaxRange(A2:A8) 5 7 14.1 Instructions: Do not create a button for this question You are not allowed to use Excel's MAX or MIN functions, or anyvariations of them, in your code. 4 25g6 15 1 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9