Copy named range, but skip blanks
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
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,