I want to add new line below selected and copy texts from selected line to this new

[warden792]

Hi guys, i have a problem. I want to programme a button which after click will add new line below selected cell and will copy all text from this line to new just created line.

[Parth007]

Hi Warden,

Usethe below code in the Commandbutton_Click

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

Works on doubleclick of cells in the active row.

[Parth007]

Wow John, Thanks got some new code in my database.. thanks for it, it will surely help me in some or the other way

[JOHN H. DAVIS]

@ Parth007 - Glad you can use it. Hope it helps warden792 as well.

[warden792]

Hi guys, have u any idea for button which undo changes?

[Parth007]

hey Warden,

You create a command button In sheet & paste the below code on its click..

Please Login or Register  to view this content.

May help

[warden792]

Run-time error '1004':
Method 'Undo' of object '_Application' failed

[Kaper]

Read remarks here:
https://msdn.microsoft.com/en-us/lib.../ff838189.aspx
Other strongly suggested reading is: http://www.excelforum.com/forum-rule...rum-rules.html (and do follow)

[Kaper]

PS. May be slightly off-topic, but strange how quickly you changed your location to "Delhi, India".
Any comment on this???