autoformat to add rows between values

[melitza]

Is there a macro or some sort of function I can use that will auto-add a row between all occurring values in a certain column? For example, add a blank row each time there is a value entered in Column C, etc.?

[VBA Noob]

See if this helps

Right click sheet tab > select view code and paste in the below

Please Login or Register  to view this content.

VBA Noob

[melitza]

Best. Response. Ever!

Thank you, thank you, thank you. Works awesome. Never seen the code edited directly like that. Now I'm intrigued about what other neat stuff can be done like this...

Thanks again.

[melitza]

Although now I'm founded. It worked perfectly this morning, then when I whipped out my spreadsheets this afternoon to really get to cracking, it stopped working. Now I go in and edit the code and nothing is happening.

Any ideas?