create a non-sheet specific macro

Question

how do I create a macro that will work with any worksheet I choose, within the same workbook? i.e. a PRINT macro whereby I select certain cells in a worksheet to be printed.

Answer 1

Not familiar with ActiveSheet. You are talking to a novice with VBA, here. Will check out ActiveSheet.

Answer 2

One way would be to create a procedure that takes a Worksheet as an argument:
public sub DoSomePrinting(byref ws as Excel.Worksheet)
'do some printing with this ws data
end sub

Rather than creating such procedure and passing in a Worksheet object, you can also use ActiveSheet to refer to the current one.