Functions and Ranges
Forget it - solved it myself.
Thanks anyhow
Nick
-----Original 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
.
|