copy and pastespecial formulas to delete formulas

seeblue

Board Regular
Joined
Jan 23, 2005
Messages
178
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.
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
L

Legacy 51064

Guest
Sub value()

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

End Sub
 

Watch MrExcel Video

Forum statistics

Threads
1,109,053
Messages
5,526,502
Members
409,704
Latest member
saialkesh

This Week's Hot Topics

Top