Hello,
So I have been working on a paste value macro and when I run it, every cell has the correctly pasted values except for one row. I have since isolated it to just writing a paste value macro for just that one row and it still comes up blank. Here is what I have written (It copies from one sheet to another in the same workbook):
Sub Macro15()
'
' Macro15 Macro
Sheets("Bids1").Select
Range("AJ21:AP21").Select
Selection.Copy
Sheets("Unit 1 Bids").Range("M143").PasteSpecial xlPasteValues
End Sub
Any ideas? Thanks.
Bookmarks