VB code to insert/delete number of rows based on cell value

[shreeja178]

Hi,

Need help with a VB code that will insert/delete numbers of rows based on a cell value.
Example: if cell value is 2, then insert 2 rows starting from row 1. if cell value is -4, then delete 4 rows starting from row 1.

Any help is greatly appreciated.

Thanks
Shreeja.

[PFDave]

How are you able to differentiate between when you want to insert and when you want to delete?

[shreeja178]

Based on the sign of number (insert if positive, delete if negative)

[shreeja178]

How are you able to differentiate between when you want to insert and when you want to delete?

Based on the sign of number (insert if positive, delete if negative)

[PFDave]

OK and which Cell are we referring to? is it any cell in the workbook (I doubt) or a specific cell or a cell contained within a specific range?

Sample workbook would probably speed this all up