Hi

Any assistance with the following would be most welcome.

I am trying to find some VBA code which will allow me to copy a
formula from an ActiveCell down to the last row in the ActiveCell
column based on the non blank cells in the column to the left of the
ActiveCell column.

For example, if the ActiveCell is equal to C5 and the range B5 to B20
contains entries.
I would like to autofill the formula from cell C5 down to C20.

To further complicate matters, the ActiveCell may be in column C in
one instance and in another it could be column D etc (in other words,
it can be in any column depending on the source data). The column to
the immediate left will always have entries in it but the number of
rows will change as well.

Thanks,

Steve

PS I am using Microsoft Office 2003 with windows XP