Excel VBA: What is wrong with this code?
Wed, 12/16/2009 - 02:50
Sub populateSchI()
Dim chargeNo As Range
Dim concat As Range
Set chargeNo = Worksheets("Schedule I").Range("A6")
For Each concat In Worksheets("2008").Range("D:D")
If concat.Value = chargeNo.Value Then
concat.Offset(0, 7).Value = "It worked"
End If
Next concat
End Sub
chargeNo and concat (range objects) are on two different tabs.
I do not think there is anything wrong with the code - I ran it and its fine. what do you want that code to do?
with me when it found a match it added "It worked" to 7 columns away from col D ... column K