John - It will work either within a macro or as a single manual action button click, but unless your code is *really* tight (i.e. you have all the bases covered re: any error conditions that might crop up, such as a Div/0 error due to an empty query response), turning it loose in full auto is *very* dangerous. I just have an order entry sheet with all commands I normally use with a macro button assigned to each one. I can then visually scan the command line and make sure all the parameters are correct before I click the button (and even then I still screw up sometimes). But, still far preferrable than having to go to the C2 site and go through Matt's arcane order entry process.
Most recently, I discovered how to make Excel do the daily Copy Downs all by itself, so unless CME has screwed us up with a table pointer change for their queries, we have the ultimate self-licking ice cream cone. See the code example below which locates the active cell based on a program sheet value, which can then be manipulated to select any desired range...
CurrentRow = Worksheets("Program").Range("K24").Value
Worksheets("Program").Cells(CurrentRow + 3, 1).Select
ActiveCell.Offset(0, 0).Range("A1:L1").Select
Selection.Cut Destination:=ActiveCell.Offset(1, 0).Range("A1:L1")
ActiveCell.Offset(1, 0).Range("A1:L1").Select
