Copy and Insert row if any cell or row is selected

[macrofan2012]

Hi There,

If any row or cell is selected I want to copy that specific rows and insert the copied row below and highlight the inserted row in any color say yellow.

I have the code which prompt a msg bot and insert the row if any row or cell is highlighted but it fills the data NOT Copying the data.

PFA the sample file to see what I mean...the file have the code too.

Can anyone help and advice to achieve this?

Thanks in advance.
Su.

[patel45]

Please Login or Register  to view this content.

[jaslake]

Hi macrofan

This is my sense of what you wish to do

Please Login or Register  to view this content.

[macrofan2012]

Hi John,

Thanks very much for the code.

That's work perfectly what I'm expecting. This inserts the copied row.

Need one more help...how can I highlight the row that is inserted so that I can know this is the row that's inserted.

Thanks,
Su.

[macrofan2012]

Hi Patel,

Thanks for your code. The code you gave, insert a row and fill the data what I needed is insert row with copied data.

For eg: If my highlighted row has data 8 Red 4588 66667
the code fills the data...like below 9 Red 4589 66668
but I want the data to be copied eg: 8 Red 4588 66667

John has given the code which does what I want.

Thanks,
Su.

[jaslake]

Hi Su

Add the line of code indicated

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[macrofan2012]

Many many thanks John. Works like a charm.

Regards,
Su.

[jaslake]

You're welcome Su...glad I could help. Thanks for the Rep.