Writing a Function

I'm working on a function that will compare each cell in a range to the cell before it, and return a 0 if they are equal and a 1 if they are different.

Know how to make the loop to do the comparison, but I am having an issue with using cells on other worksheets. In subroutines, I can use Worksheets("Worksheet Name").Select to change worksheets and then pull data. When I write a function, I cannot change worksheets (even Worksheets("Sheet Name").Cells() doesn't work.)

What's the trick here? What's the command to change worksheets so I can pull cell data from other sheets for a user-defined function, or is that not possible?

Use

Worksheets("Sheet Name").Range("A1")

No need to select.

HTH

Jason

many say that it is bad practice to access information directly from within a UDF like that. Better might be to pass the range to the function via the argument list. To illustrate

function compare1(range1, range2)
compare1=0
If range1.cells(1,1).value=range2.cells(1,1).value then compare1=1
end function

Then, when you call the function from the spreadsheet, you just reference the range from the other worksheet just like in any other built in function. (=compare1(sheet1!a1,sheet2!a2))