Hi Brian,

Am Wed, 22 Oct 2014 06:36:47 -0700 (PDT) schrieb Brian:

my problem is determining how to make the formulas the same number as the number of entries in column CY.

LRow is the last cell in column CY:

Dim LRow As Long

LRow = Cells(Rows.Count, "CY").End(xlUp).Row
Range("CZ1:CZ" & LRow).Formula = "Your formula"


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional