I would like to compare a list of cells in VBA. This I can do if I know the cell reference using:

If range ("A1") = range ("B1") then msg box etc etc etc

But the cell range will be user defined within an excel spreadsheet. So, I am looking for the code that will look in Cell A1 to find the reference of the cell it should go to (this might be in another sheet). I know this is easily done in excel using the indirect formula, but how to do it in VBA is driving me crazy.

Thanks