Once you set up your VBA code correctly, all you have to do is press a button and all the targeted rows will be deleted. How to Remove the Decimal When Using RAND in Excel. When you use the RAND ...