What is the most efficient way to copy and paste in VBA. For some reason I always have to select the cell that I want to paste into. Not only that but I seem to have to do:
Range("A1").Select
activesheet.selection.paste
Why is that? Whats the point, is there any way to cut,copy, and paste without using active cells?