VBA code to add a row based on a cell value

[Mr_Leeroy]

Hello,

I've a very large excel spreadsheet and I'd like to add a new row above a value in a coloumn using VB code

The value is "1" in column "B" and the the new row is to be inserted everytime the value "1" appears in that coloumn.

Thanks

[davesexcel]

Loop from the bottom

Please Login or Register  to view this content.

[modytrane]

[modytrane]

sorry, didn't see prv reply. didn't mean to duplicate.

[mjr veverka]

To the collection ...

Please Login or Register  to view this content.

[Mr_Leeroy]

Thanks for this, I'll try this tomorrow as I've just left work
Mr leeroy

[davesexcel]

To the collection ... ............

Nice one, should be mentioned the code only works as long as Column A is filled in.

[mjr veverka]

Nothing and nobody is perfect ...