Is there a way to reference a cell on a non-active sheet, without first
activating or selecting that sheet?

I'm writing code to compare 2 near-identical tables and copy the differences
into a summary table.

I'm finding that jumping back and forth between the two tables takes quite a
lot of time (when it's done for hundred's of rows with ~20 columns).

Is there a way for me to reference the cells on each sheet without
activating them? The cells to be compared are in identical places, just on
different sheets.

For example:

If Worksheet(1).Range(R,C).Value <> Worksheet(2).Range(R,C).Value Then ...

Is this possible?

Thanks,
KellyB