Insert row after last date of the month not necessarily 30 or 31

[mangesh.mehendale]

Hiii Everybody,
Want insert rows after change of month.. excel attached...
15/04/2014
30/04/2014
31/05/2014
30/06/2014
31/07/2014

[event21]

Hi -

Maybe;

Please Login or Register  to view this content.

event

[mangesh.mehendale]

not working... inserting row after every 31 or 30

[event21]

Hi -

try

Please Login or Register  to view this content.

event

[mangesh.mehendale]

Yes done but showing type mismatch error in my actual sheet...
also explain the coding

[mangesh.mehendale]

Untitled.png


Type mismatch at this line

[event21]

Yes done but showing type mismatch error in my actual sheet...
also explain the coding

Hi -

The code is really simple, just looping starting from the bottom going up, checking if the top cell month is not equal to the current cell month, then insert row.
not sure of the error. the column A should be date.

event