Functions and Ranges
 

If you've defined your arguments as ranges, simply use the Address property
to retrieve its address:

Function TEST(MyRange as Range)
TEST = MyRange.Address
End Function
--
______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP-Excel


"Nick" wrote in message
...
Hiya

I have made a function that has four parameters.

Two of them are ranges but the function is taking the
value of the range rather than its location which is what
I want. So if I input B7 into the function I get the value
of B7 rather than Range("B7").

I have defined the variable as a range object but this
seems to be wrong. What do I need to define these two
variables as?

I am using Excel 2000.

Any help would be much appreciated :)

Nick