Morning all,
is it me being dumb or just not enough coffee yet...
Ok so being 8am this morning got asked to try clean up a report, thought ye no problem be easy, work that vba magic on it.
So i wrote a quick test code
[vba]
Sub proDelete()
Range("B1").Select
Do Until Selection.Value = ""
If Selection.Value = "UNEEDED" Then
'Selection.EntireRow.Delete
MsgBox "Delete ME"
Else
Selection.Offset(1, 0).Select
MsgBox "Keep ME"
End If
Loop
Range("A1").Select
End Sub
[/vba]
but this wasnt working.. to find out the the data in Column J is all in fact VLOOKUPs
[vba]
=VLOOKUP(F2,'Data'!A:B,2,FALSE)
[/vba]
now i ve bever had to deal with VBA and VLOOKUPs together so, just wondering if thers an quick easy way to read the VLOOKUPS Value its returned like "UNEEDED"
THANKS IN ADVANCE