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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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))