Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
If ActiveCell = "" Then ActiveCell.Offset(0, -1).Range("A1").Select 'move one cell left from whereever active cell is Range(Selection, Selection.End(xlDown)).Select ActiveCell.Range("A1:C995").Select Selection.Copy Windows("CU50BySalesOrder.xlsm").Activate Sheets("MasterCopy").Select 'elminate the need to start marco on specific cell Range("D2").Select Selection.End(xlDown).Select Selection.End(xlDown).Select Selection.End(xlUp).Select ActiveCell.Offset(1, 1).Range("A1").Select ActiveSheet.Paste ActiveCell.Select End If
Join the community of 500,000 technology professionals and ask your questions.