Referencing cells on non-active sheets

[Guest]

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

 

[Tom Ogilvy]

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

You almost had it.

 

[Guest]

That does work. I was using the Range(R,C) property before and it wasn't
working. Not sure why. The Cells property does work.

Any info on why this is?
Thank.

 

[Tom Ogilvy]

Range will only accept multiple arguments if they are ranges or can be seen
as ranges.

Range("A1").Address

or
Range("A1","B2").Address

Range doesn't accept row/column as separate arguments. That is why we have
CELL.