Macros- Automatically add a new row when cell value is greater than 0

[anyi1989]

Hi All,




I'm in real need of some help with creating a macro which will automatically insert a formatted (bold, centered) row in B20- I20 sheet 1, when the value in Sheet 2 Column N row 26 becomes greater than 0.







Please let me know if you require any further details in order to be able to assist.




Thank you

 

[My Aswer Is This]

A Worksheet_Change event: triggers when you change a cell (or range of cells) value manually or in a macro -- it will not be triggered from a change showing up in a formula or from a change of format.
Learn more here:Event Macros, Worksheet Events and Workbook Events