Run-time Error 1004 - Method 'Range' of object '_Global' failed

[Phoenix22]

Hi,

I get an error on the line " Range("range_mtl&quot.Select " in the code below. It complains that "Method 'Range' of Object '_Global' failed.

***********************************

Windows(bh_report_filename).Activate
Names.Add Name:="range_mtl", RefersTo:="=MTL!" & "C2:" & "F" & row_mtl
Sheets("MTL&quot.Activate
Range("range_mtl&quot.Select
Selection.Copy

**********************************

I don't really understand why this is happening because if I just use "Range("range_mtl&quot.Select without prefixing it with an object, shouldn't it just use the ActiveSheet object?

Any help would be much appreciated, thanks.

 

[Zathras]

There are just too many ways this can go wrong:

How are the variables declared (Dimmed)?
What is in bh_report_filename?
Is the workbook open?
What is in row_mtl?
Is there a sheet named MTL in the workbook?

 

[TonyJollans]

Hi Phoenix22,

Are you actually defining a name for a valid range? What is variable row_mtl? If it is empty, for example, you will get that error.

Enjoy,
Tony