Hi, I am having trouble with the following code that selects all rows to the bottom starting with 2nd row in on workbook, and pastes into another. Everything work fine if I use just Paste, but the code breaks if I am using PasteSpecial xlPasteValues. Why is it happing? How can I paste values using the code I've created so far?
Application.Goto Reference:="R2C1:R2C100" 'where R is row and C is column.