Hi All,
I am wondering if there is anyway to set a variable as a range.
This is what I have
Sub Macro ()
Dim rng As String
rng = "A2:A100"
If (rng = "Power Group Overhead") Then
Range("A2:A100").Value = 1
Else
Range("A2:A100").Value = 2
End If
End Sub
Whenever I run this code, all I get is 2, but there is "Power Group Overhead". So the answer should be a mix of 1 and 2.
Thanks All
Bookmarks