Adding a new row when value changes

[zanguard80]

Hello, I'm trying to add a new row when numbers in a sequence change, but I want the code to only apply to changes between cells B10:B150.

I'm using this at the moment (courtesy of JBeaucaire):

Please Login or Register  to view this content.

How do I make this apply to cells B10:B150 only?

Thanks.

[HaHoBe]

Hi, zanguard80,

maybe

Please Login or Register  to view this content.

Ciao,
Holger

[zanguard80]

Thanks, that works perfectly.