To pass an argument when pressing a button in an Excel sheet.
When you right click an Excel button to assign a macro, enter the macro name and argument as such. 'Macro1(1)'
Note the single quotes around the whole thing.
This example will call the macro Macro1, and pass it the number 1.
I hope this will help someone else.
ReBoot