Hi,

i have made global string constants for ranges.

PHP Code:
Global Const G_Cl As String "G2:G13"
Global Const G_Vl As String "I2:I13"
Global Const G_VlS As String "L2:L13" 
i want to clear these ranges using a single line of code.

PHP Code:
With wkData
    
.Range(G_ClG_VlG_VlS).ClearContents
End With 
but i get error:

"Wrong no of arguments or invalid property assignment!"
i even tried this:

PHP Code:
With wkData
    
.Range(Array(G_ClG_VlG_VlS)).ClearContents
End With 
OR

PHP Code:
With wkData
    
.Range([{G_ClG_VlG_VlS}]).ClearContents
End With 
how can i clear all the ranges in one line of code?