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 ...

How to create a VBA procedure that ... ll find Personal.xlsb in the Project Window, as shown in Figure B. Double-click Module1 to open its code sheet and delete the procedure you just created.