VBA Variable as a Range (A1:A100)

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

Your Else will always be True since the String value "A2:A100" is never equal to the String value "Power Group Overhead".

If your intent was to check each cell in the range then a loop can be used. e.g.

Please Login or Register  to view this content.