Problem with VBA Machine Code vs Binary...Maybe?

[SBF12345]

I have a bit of code that is returning dates values inaccurately. The search values that are generating the problem all begin with 2 as in February. Dates that begin with 2 are being found as December dates. Its as if the find function is adding a "1" before the two somehow. Not sure what to think here? Is this a machine code vs binary problem perhaps?

RngEnd2 = Cells.Find(What:=EndDate, After:=ActiveCell, LookIn:=xlFormulas, _        LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
        MatchCase:=False, SearchFormat:=False).Address(1, 1)

 

[MARK858]

Try....

EndDate.Resize(, 2).Offset(zz, 0).Copy

 

[SBF12345]

I have something wrong with my snytax on the other line in the loop. object defined error

Sheets("LowDistCharts").Range(Cells(5, aa + 10)).Offset(zz, 0).PasteSpecial xlPasteValues

 

[Norie]

Get rid of Range.

Sheets("LowDistCharts").Cells(5, aa + 10).Offset(zz, 0).PasteSpecial xlPasteValues

 

[SBF12345]

Back to the first line in this short For loop. With the line below the date value is pasting into the destination sheet but it is including no adjacent column data. When the data is pasted into the destination sheet it pastes with two adjacent columns, but the right side is blank. Any ideas why this might be occurring?

EndDate.Resize(, 2).Offset(zz, 0).Copy

 

[SBF12345]

Disregard. The EndDate range variable is using an incorrect sheet as a basis from which to copy.