Functions and Ranges

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

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
 
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
 
Back
Top