Select Copy and Paste Data

Here MS Excel related topics will be posted.
Post Reply
admin
Posts: 2062
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Select Copy and Paste Data

Post by admin »

Sub Select_copy_paste_Data()
'
' First select data using Ctrl Down and Ctrl Right keys
'

Range("A2").Select

Range(Selection, Selection.End(xlDown)).Select
Range(Selection, Selection.End(xlToRight)).Select

Selection.Copy

Range("E3").Select

ActiveSheet.Paste

End Sub
Malik Sikandar Hayat
admin@erpstuff.com
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests