Change VBA to paste special

[RAB29]

I am using the macro below however its copying formulas not values. How do i change this so it paste special please?

Sub Move_FlightPath()

'SelectedCell = ActiveCell.Address
If Selection.Value = "In The Hangar Waiting" Then
Workbooks.Open "V:\1 EBS Management System DO NOT CHANGE DOCUMENTS Q\Continuous Improvement\Continuous Improvement\C.I. Projects\Proposal Documents\Flight Path trial.XLSM"
Workbooks("Enquiry Proposal Trial.XLSM").Activate
'Worksheets("Enquiry").Activate
'Range(SelectedCell).Activate
ActiveCell.Offset(, 1).Resize(1, 19).Copy Destination:=Workbooks("Flight Path trial.XLSM").Worksheets("In The Hangar Waiting").Range("B" & Rows.Count).End(xlUp).Offset(1, -1)
End If

End Sub

 

[Fluff]

How about

Workbooks("Flight Path trial.XLSM").Worksheets("In The Hangar Waiting").Range("B" & Rows.Count).End(xlUp).Offset(1, -1).Resize(, 19).Value ActiveCell.Offset(, 1).Resize(1, 19).Value

 

[RAB29]

How about

Workbooks("Flight Path trial.XLSM").Worksheets("In The Hangar Waiting").Range("B" & Rows.Count).End(xlUp).Offset(1, -1).Resize(, 19).Value ActiveCell.Offset(, 1).Resize(1, 19).Value

What would this replace please?

 

[Fluff]

The copy destination line in your code.

 

[RAB29]

The copy destination line in your code.

It comes up with run time error 438

 

[Fluff]

Oops missed the = sign, it should be

Workbooks("Flight Path trial.XLSM").Worksheets("In The Hangar Waiting").Range("B" & Rows.Count).End(xlUp).Offset(1, -1).Resize(, 19).Value = ActiveCell.Offset(, 1).Resize(1, 19).Value

 

[RAB29]

That works. Great thank you.
Any chance you can explain the difference to me please. I'm new to this and in process of teaching myself.

 

[Fluff]

When you use Copy destination, like you did, everything is copied, formula, formatting etc. However when using .Value=.Value it only copies the values & nothing else