ExcelBanter - 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
.