Reversing Order of Values in Range Variable

[vthokienj]

I have a function that receives values from a worksheet as a Range variable:

Public Function Interpolate(x As Double, Xi As Range, Yi As Range)

Lets say that Xi has two values, which I can access like:

x1 = Xi(1)
x2 = Xi(2)

I want to reverse the two values, and I don't seem to be able to write directly to the variable, so
this can't be done:

Xi(1) = x2
Xi(2) = x1

How can you reverse the order of these values? They must stay in a Range object.

Thanks

 

[vthokienj]

The corrupted workbook does seem to be the case, as this code works on another system. Thanks for the help in solving this issue, I should be set once I move code over to a new workbook.