M
Munchkin
My goal here is to copy "NewRecord" and paste values only in the first blank
cell in column A on the Payment History sheet, while skipping blanks rows.
"NewRecord" has 22 rows with formulas in columns A, B & C. Sometimes all 22
rows will have data entered, sometimes only the 1st row.
The marco works, but does not skip the blank rows in NewRecord - is it
because there are formulas present? How do I fix this?
Also, how do I assure my macro is pasting on the first blank row of column
A?
Application.Goto Reference:="NewRecord"
Selection.Copy
Sheets("Payment History").Select
Range("A1").Select
Selection.End(xlDown).Select
Range("A292").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=True, Transpose:=False
End Sub
cell in column A on the Payment History sheet, while skipping blanks rows.
"NewRecord" has 22 rows with formulas in columns A, B & C. Sometimes all 22
rows will have data entered, sometimes only the 1st row.
The marco works, but does not skip the blank rows in NewRecord - is it
because there are formulas present? How do I fix this?
Also, how do I assure my macro is pasting on the first blank row of column
A?
Application.Goto Reference:="NewRecord"
Selection.Copy
Sheets("Payment History").Select
Range("A1").Select
Selection.End(xlDown).Select
Range("A292").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=True, Transpose:=False
End Sub