autoformat to add rows between values

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.?

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.

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?