Macro to insert rows

[bradyj7]

Hi there,

In column A I have time values as in the example below. You'll see that they are every 2-5 secs approximately. The number of rows varies considerably in each workbook depending on how long the recording lasted. I'm looking for a macro that will find the last row of data in Col A and insert rows between the ones that are there so that there is a row for every second.

 Date 
28/03/2011 08:08:23
28/03/2011 08:08:26
28/03/2011 08:08:31
28/03/2011 08:08:37
28/03/2011 08:08:41
28/03/2011 08:08:47
28/03/2011 08:08:51

So as an example I'd like it to do this

28/03/2011 08:08:23
28/03/2011 08:08:24
28/03/2011 08:08:25
28/03/2011 08:08:26
etc

Appreciate any ideas

Thanks

John

 

[craig.penny]

You're quite welcome!