Here is what I am trying to accomplish.
1) Open two spreadsheets
2) Copy All on the first one
3) Go the second one
4) Delete the workeheet (OutcomesXL)
5) Move the cursor to A1
6) Paste the copied text and formulas
7) Select Row A
8) Delete Row A
9) Save the worksheet
10) Close the Worksheet
I am trying to combine two macros. Individually, they work. Combined they don't. I do not have #10 included in the VBA.
Any help on this? Thanks.Sub Outcomes() ' Deletes all the data ' Keyboard Shortcut: Ctrl+o Worksheets("OutcomesXL").Cells.Clear ' Pastes data and deletes Row 1 Range("A1").Select ActiveSheet.Paste Rows("1:1").Select Application.CutCopyMode = False Selection.Delete Shift:=xlUp ActiveWorkbook.Save End Sub
Bookmarks