Thank you Jacob, this worked for me.

Mike, I will try yours out as well to see which works best for my project.
--
Thank you, Jodie


"Jacob Skaria" wrote:

Try

lngRow = Columns(2).Find("Grand Total").Row - 1
Range("A1:A" & lngRow).Formula = "=B1+C1"

If this post helps click Yes
---------------
Jacob Skaria


"Jodie" wrote:

I want to write a macro that copies and pastes a formula down column A, but I
want it to stop where column B equals "Grand Total". Can anyone help with
this?
--
Thank you, Jodie