Method 'Range' of Object _global failed

[Juno123]

Hi Friends,

I am getting a Method 'Range' of Object _global failed error while trying to execute the following code-

If Range("COMPG") = "" Then
Sheets("ReportSheet").Select
Range("CompG_RANGE").Select
Selection.Delete Shift:=xlUp
End If

The error occurs in the 3rd line (Range("CompG_RANGE").Select)

Range "COMPG" and Range "CompG_Range" exist in 2 different sheets within the same workbook.

Thanks in advance,
Juno

 

[GlennUK]

What sheet does CompG_RANGE exist in?