Hi,
I need to know how to write a VB code that will:
copy selected data
prompt for user to input the destination cell
paste data into destination cell (could be in another w/sheet)
Hats off to VB gurus.
Thanking in advance -Uma
Hi,
I need to know how to write a VB code that will:
copy selected data
prompt for user to input the destination cell
paste data into destination cell (could be in another w/sheet)
Hats off to VB gurus.
Thanking in advance -Uma
Try this, but it needs to be triggered, you could have a button run the code.
Sub CopySelection() Dim T1, T2 As Variant T1 = InputBox("Enter Sheet in this format Sheetx ", "To which Sheet") T2 = InputBox("Enter Range in this format A1 ", "To which Cell") With ActiveSheet Selection.Copy Destination:=Sheets(T1).Range(T2) End With End Sub
Not all forums are the same - seek and you shall find
Thank you. It works great. !!!
Thanks a million.
I can carry out my task much more effeciently now.
Uma
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks