Maybe you need to qualify the Range, e.g.:
Worksheets("Sheet1").Range("F" & LstRowNdx + 14).Value
Without the qualification, Excel assumes the active sheet.

HTH,

Merjet