Howdy Ya'll

I'm trying to write a formula that, when input in cell 1, will change
propeties or values of a second cell or range. Whenever I try to
manipulate the contents of a second range, the function always
terminates at that line (with no error). The conceptual code is as
follows:

Function misc_function(input1 As Range, input2 As Range)

Worksheets("worksheet2").Range(a2).Formula = input1
Worksheets("worksheet2").Range(a3).Formula = input2

misc_function = Worksheets("worksheet2").Range(a4).Formula

MsgBox ("It's Over!")

End Function

I've tried variations on this that change the active selection with no
luck either. Is there a way to do this sort of thing? The idea is that
someone can change the formulas or calculations on "worksheet 2" and
thus the output of the function without having to write any VBA (very
helpful for non-VBA literate users). Thanks for your help.

Nathan


--
Nate_Dogg_Bry
------------------------------------------------------------------------
Nate_Dogg_Bry's Profile: http://www.excelforum.com/member.php...o&userid=27457
View this thread: http://www.excelforum.com/showthread...hreadid=469707