I have 2 pretty easy ?'s but i can't figure em out.....
1). if you have a cell selected, how do you code it to move down 1 row.
2). if you have a range selected, how to you code it to paste.
1). if you have a cell selected, how do you code it to move down 1 row.
Code:
Dim LastRowDB As Long
LastRowDB = Cells(Rows.Count, "D").End(xlUp).Row
Range("A" & LastRowDB).Select
'NEED HELP HERE.goal is to move the actice cell down ONE ROW
ActiveCell.MoveDown
2). if you have a range selected, how to you code it to paste.
Code:
'Copy CurrentDays Invoices
LastRowPO = Cells(Rows.Count, "D").End(xlUp).Row
Range("A2:M" & LastRowPO).Select
Selection.Copy
'Open the CompilingMaster tab (database) file
Workbooks("POQuantityTrackingReport.xls").Activate
'NEED HELP HERE.goal is to simple paste the Selection from above
Selection.Paste
'also tried
ActiveCell.Paste