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
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