Dim LoanCount as integer
LoanCount = 10
Sheets("StressScenarioReport").Range("A5:A" & LoanCount + 4).Copy_
Destination:=Sheets("LoanInputs").Range("O5:O" & LoanCount + 4)
or
Sheets("StressScenarioReport").Range("A5:A" & LoanCount + 4).Copy_
Destination:=Sheets("LoanInputs").Range("O5")
'both are the same. Copy and Destination need to be in the same line.
