Macro to auto calculate selective excel sheet where RAND Between formula is being used

I have a rand between formula on my sheet and would like to auto compute selective area of excel sheet without changing the value again in rand between cell.

The issue I am getting is when the form is set to auto calculate, field value of RANDBETWEEN also refreshes.