Dim fnd As Range
On Error Resume Next
Set fnd = Range("B:B").Find(Range("A397").Value)
fnd.Resize(24, 8).Copy [K401]
fnd is a date, but it is a formula referencing another cell. The entire range is basic formulas referencing other cells and I would like the values of those cells to be pasted instead of the formulas being pasted.