Hi all,
I have a Macro which pings an e-mail for a team confirming that a tracker has been updated, while at the same time updating said tracker.
The tracker update is a standard copy and paste, with a range selections as follows;
This works fine if there is more than one line on the form to copy and paste. However when there is just one line it copies the entire sheet, which causes havoc with the code when I then try and paste into the tracker.
The full code is as follows;
Any ideas how I can stop this?
I have a Macro which pings an e-mail for a team confirming that a tracker has been updated, while at the same time updating said tracker.
The tracker update is a standard copy and paste, with a range selections as follows;
VBA Code:
Range("A2:W2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
This works fine if there is more than one line on the form to copy and paste. However when there is just one line it copies the entire sheet, which causes havoc with the code when I then try and paste into the tracker.
The full code is as follows;
VBA Code:
Range("A2:W2").Select
Range(Selection, Selection.End(xlToRight)).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy
Workbooks("Milestones Change Request Tracker.xlsx").Activate
Sheets("Tracker").Select
Range("A" & Rows.Count).End(xlUp).Offset(1).Select
Selection.PasteSpecial Paste:=xlPasteValues
Any ideas how I can stop this?