Repeating Macro until I get an empty row

Hi totally new to macros, but i figured out how to record one and it works. Now I need to make it repeat for several rows until it gets to an empty row. see below Sub Macro5() Range("P9").GoalSee...

Formulas and Functions

Haytham Amairah
Feb 12, 2019
Hi,

You can use the For Each statement to loop through each cell in the selection and apply the code to it.
But you have to select the range of cells that you want to change before you run the code.
Sub Macro5()

For Each cell In Selection
cell.GoalSeek Goal:=0.25001, ChangingCell:=cell.Offset(0, -9)
Next

End Sub

Hope that help

Forum Discussion

Repeating Macro until I get an empty row

Resources