VBA code to insert blank rows in a column with dates, after every new date

[emomvp]

Hi I have a few files at work and in a column "J" I have different dates. For example from J2:J11 I have 01.01.2011, then from J12:J53 i have 17.01.2011 and so on to the end (more than 10 000 rows full with dates). My question is if there is a way with VBA marco to insert a blank row after the end of every date. (After J11 then after J53, so everytime the date change it will insert a blank row.) Thank you in advanced

P.S. Can't provide the files, 'cos it's a classified

[JBeaucaire]

It's easy to provide a "declassified" example file, right?

This little macro should do that:

Please Login or Register  to view this content.