vba to insert 3 blank rows at the change in col h

[fvisions]

Hello, I have read the posts in this forum looking for one similar to what I am looking for but I am unable to change them to what I am looking for. I have a workbook with multiple worksheets. I am have created command buttons on one tab to step the end user through to do multiple things. The last piece is to press the command button on the command button tab and have the sheet labeled "Installation wkg" and insert 3 blank rows at the change in column H (sheet has col A:AD) I am not sure where to being so I attempted to copy other examples and edit but that has not worked for me. Is it possible to help me get started?

 

[fvisions]

referring to where one series of values ends and another series of values begins

 

[fvisions]

My question was directed at the 'Change' in column H. Are you referring to any change made by a user in column H, or are you referring to where one series of values ends and another series of values begins? @MARK848 and @Joe4 addressed the value series, and my code addresses the user input changes.

referring to where one series of values ends and another series of values begins

 

[MARK858]

the code adds 3 rows at row 2

Make the change in red

For insRrw = .Cells(.Cells.Rows.Count, "H").End(xlUp).Row To 3 Step -1

 

[fvisions]

Make the change in red

For insRrw = .Cells(.Cells.Rows.Count, "H").End(xlUp).Row To 3 Step -1

Works Perfect now!! Thank you

 

[MARK858]

You're welcome, happy we could help

 

[JLGWhiz]

Thanks for the feedback.
Regards, JLG