Macro Help

[Mldeuser]

I would like to create a macro that will look at column "C" and for every cell that is populated until the first 1 row break (which varies from workbook to workbook) the rows after the first break are hand populated.

Will put a formula into each corresponding cell in column "J"

Is this possible?

Thanks
Mark

 

[Legacy 68668]

try

Range("c1", Range("c" & Rows.Count).End(xlUp)).Offset(, 7).Formula = _
"=YourFormulaInJ1Here"

 

[Mldeuser]

How do i make it stop when it finds the first empty row.

Thanks
Mark

 

[Legacy 68668]

Have you tried the code?

 

[Mldeuser]

Yes I have, it does not stop at the first empty row.

 

[Legacy 68668]

then try

Range("c1", Columns("c").Find("",Range("c1"),,xlWhole)).Offset(, 7).Formula = _
"=YourFormulaInJ1Here"