How to repeat the macro for a range of rows

[adboy14]

Hi people,

First time on here and i'm hoping to get some help on a macro i've been working on. I don't come from a coding background and so i've been searching as best i can for a solution but to no avail so far.

I have a macro which works as i want:

Sub Simple_if()
If Range("AB9").Value > 0 And Range("AK9").Value = "" Then
Range("AK9").Value = Range("AB9").Value
Range("AI9").Value = "Open"

End If

End Sub


I want this macro to repeat from row 9 to row 36. Is there a simple way to do this as opposed to having 28 seperate macros?

Hope this makes sense.

Thanks.

[mrbarba]

Try this:

Please Login or Register  to view this content.

[adboy14]

Great thanks for this it gets me so close!

I have now found that I need another condition being that if cell AB is blank then it moves on otherwise do the above formula.


Again, any help will be greatly appreciated.

Thanks

[mrbarba]

I have now found that I need another condition being that if cell AB is blank then it moves on otherwise do the above formula.

If I understood you correctly, this should do it:

Please Login or Register  to view this content.

[adboy14]

Perfect exactly what I was looking for!!! Thanks for the help!