I keep hitting my head against the wall with this formula. I would the data being copied to paste in a certain column only if the information in the range containes the month May in it. I tried Dim May as date but it didnt work then I tried an IF formula telling excel to pick up the word May and I keep getting the error message type mismatch. This is what I have so far and I'm not getting anywhere with it.
Dim wksSource As Worksheet Dim wksDestination As Worksheet Dim vntCloneValues As Variant Dim nextrow As Long Set wksSource = Sheet3 Set wksDestination = Sheet1 If Range("F7:F12").Value = "May" Then vntCloneValues = wksSource.Range("F7:F12").Value nextrow = Sheet1.Cells(Rows.Count, "C").End(xlUp).Row + 3 wksDestination.Range("C" & nextrow).Resize(UBound(vntCloneValues), 1) = vntCloneValues Erase vntCloneValues Sheet3.Range("F7:F12").ClearContents End If End Sub
Can anyone help me complete this code? Am i way off or am I close?