>> Now, if you call a macro with a cell range as its argument, how does 
>> that work?
> 
> Not sure what you mean, you can pass arguments on in the normal manner 
> i.e. Call Macro1(MyRange) from within another macro, or do you mean how 
> do I pass what you've selected in the worksheet to the macro you're 
> running? Which would be
> 
> ActiveWorksheet.ActiveCell or better ActiveWorksheet.Selection

Actually I meant "how do I make it so I can write =MyMacro(A4:C9) in a 
cell formula and have it actually work properly?"

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message