This should be an easy one for you.
Why do i get error 1004 method range of object global failed in this one??
it seems pretty strait forward
What am i missing?
Sub test()
Dim xrows As Integer
Dim x As Integer
Dim y As Variant
xrows = (Range(Cells(1, 1), Cells(1, 1).End(xlDown)).Count) - 4
For x = 4 To xrows
y = Left(Range(Cells(x, 1)), 2)
Next x
End Sub
Why do i get error 1004 method range of object global failed in this one??
it seems pretty strait forward
What am i missing?
Sub test()
Dim xrows As Integer
Dim x As Integer
Dim y As Variant
xrows = (Range(Cells(1, 1), Cells(1, 1).End(xlDown)).Count) - 4
For x = 4 To xrows
y = Left(Range(Cells(x, 1)), 2)
Next x
End Sub