Hi,

I have a workbook with three worksheets and several existing procedures which are working OK. I am attempting to add a new procedure which needs to access one of the other worksheets, but I am getting a persistent run-time error 1004 "Method 'Range' of object '_Worksheet' failed" when trying to establish an active cell on the destination sheet.

The code is copied from other procedures where it works successfully, and is as follows:

'Look for Existing Chart
Sheets("Chart List").Activate
Range("CFirst").Select

The range "CFirst" is defined with scope "Workbook", and error still occurs if I replace the range name with the cell reference "B2". Somewhere there must be a mirror not aligned correctly, but I have not been able to find it. Can anyone help please?

Thanks

Ray