Anyone able to chop this code down at all? Trying to remove the "select" from certain places but not to sure on the syntax![]()
ActiveCell.offset(-1, 11).Range("A1:B10").Copy Sheets("Pairs Trading").Select ActiveCell.offset(3, 0).Range("A1").Select ActiveSheet.Paste Link:=True Sheets("Market Depth").Select ActiveCell.offset(-1, 18).Range("A1:A10").Copy Sheets("Pairs Trading").Select ActiveCell.offset(0, 3).Range("A1").Select ActiveSheet.Paste Link:=True Sheets("Market Depth").Select ActiveCell.offset(-1, 17).Range("A1:A10").Copy Sheets("Pairs Trading").Select ActiveCell.offset(0, 1).Range("A1").Select ActiveSheet.Paste Link:=True Sheets("Market Depth").Select











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks