# copy and pastespecial formulas to delete formulas

#### FROGGER24

##### Well-known Member
I have a worksheet that has an over abundance of formulas so what I would like to do is go to a20 to last used row in column a -20 rows then across to column DR then copy and paste special to get rid of formulas.

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.
Sub value()

With Sheets("Sheet1").Range("A20:DR" & Cells(Rows.Count, "A").End(xlUp).Row-20)
.Value = .Value
End With

End Sub

Thanks A whole bunch for the code works fantasic

Replies
9
Views
128
Replies
0
Views
131
Replies
5
Views
187
Replies
4
Views
183
Replies
3
Views
122

1,221,125
Messages
6,158,074
Members
451,463
Latest member
PowerIon2

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back