Select Method of Range class fail

Code selects a cell on the Report sheet, then looks for the matching cell in Row 1 of the Database.

As shown on the attached, it seems to "find" the matching cell, but when asked to select the cell it generates a RunTime 1004 Error

Can't see why, and it's the same syntax I've used almost continuously for years?

All solutions, suggestions or pointers received gratefully as ever

Ochimus

You're trying to select a cell that's not on the active sheet.

Activate "DATABASE" first, then select "MATCHED".

BSB

Badly,

Major apologies for not responding promptly.

I was sure I thanked you at the time, but obviously missed something out, because I've just seen I have a number of "open" queries including this one!

I was trying to avoid using either "Activate" or "Select", which obviously slow things down, and using them is clearly seen as "Not a Good Thing" on most Forums, but ended up using your approach.

Ochimus