Hello Everyone.
Let me describe the problem quickly.
Sub Data_Copy()
Unload CopyData 'turns out one one the buttons I use
Dim ToRange As Range
Set ToRange = Application.InputBox("Enter the range to where you want to copy : ", Type:=8)
Sheets("Data").Select
Range("C2:C24").Select
Selection.Copy ToRange
End Sub
I want to copy the data from "Data" worksheet, choose a new range in the InputBox and paste the selection there. The problem I cannot defeat is: how to choose a range in a different workbook (another Excel file opened), as I cannot do that with my macro. When the InputBox opens, I can only choose worksheets within my current excel file.
TIA for your help!
Bookmarks