Is there a macro or formula that would allow me to designate say cell A1, so that when the cell is selected the cells in say range B2-C10 are printed or the print box comes up with those cells in place?
You won't be able to do it via a formula, but the following might help. Right-click on the worksheet tab, select 'View code' and copy and paste in the following: -
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim ans As Integer
If Target.Address <> "$A" Then Exit Sub
ans = MsgBox("Print out cells?", vbYesNo + vbQuestion)
If ans <> vbYes Then Exit Sub
You might want to name the range to be printed out and use Range("YourName").PrintOut instead.