explainations

After some research I have found a solution for counting date occurrences within a cell range. Could someone give me a breakdown of the following function and a reasonably simple explanation of how it works. =SUMPRODUCT(--(TEXT(A1:A100,"mmmyyyy")="Jan2000")) Thank you

Range("A65536").End(xlUp)(1, 2) = txtTitle.Text 'Prints the text in the Title column' This code goes to a text box on a form and it prints whatever I type in the text box directly into the first blank row in the second column. I found this code on this site, but I would like to understand it...

;)Meldoc prepapred this code: Please expplain how this code works each line. Thanks alot!!! Sub Pedie() With Sheet1 lr = .Cells(Rows.Count, "A").End(xlUp).Row For i = 2 To lr If .Cells(i, "D").Value >= .Cells(2, "H").Value Then .Range("A" & i & ":G" & lr).Copy...