>>> 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?"
> 

Ah, so you want to convert your macro into a formula function? I would 
look at the manual for you... but I uninstalled M$ Office a while ago :)

Post a reply to this message