![]()
Sub ex() Dim x, r As Range Set x = ActiveSheet.Range("A:A") For Each r In x If r.Value = "daveyc18" Then r.Offset(0, 1).Value = "20000" Else If r.Value = "batman" Then r.Offset(0, 1).Value = "2000" End If Next End Sub
![]()
Sub ex() Dim x, r As Range Set x = ActiveSheet.Range("A:A") For Each r In x If r.Value = "daveyc18" Then r.Offset(0, 1).Value = "20000" Else If r.Value = "batman" Then r.Offset(0, 1).Value = "2000" End If Next End Sub
Thanks!
Raga.
Please,mark your thread [SOLVED] if you received your answer.
Click the little star * below, to give some Rep if you think an answer deserves it.
I learnt so many things from these links.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks