Thanks that was it. There was text in the way.

"Sam Wilson" wrote:

Type mismatch is telling you that the content of .cells(k+2,10) is not a
number!


"Philosophaie" wrote:

Tried a few things:

Added an array to all the variables.

added CDbl to all double dim.
Pup(k) = CDbl(.cells(k+2,10))

It keeps saying "Type Mismatch" error.