Excel VBA not recognizing cell value

Originally Posted by her.rockstar

AlphaFrog I'm afraid that didn't work.

For the code were you suggesting this?:

With wsSource
    valChange = .Range("C16").Value
    strCol = Format(.Range("C14").Value, "MM-DD-YYYY")
    strRow = .Range("C18").Value
End With

That's what I was suggesting. Is MM-DD-YYYY the correct date format? I don't know what date format you are actually using.