fabriciofcmiranda
Board Regular
- Joined
- Jun 27, 2006
- Messages
- 62
I have a big code that has a part that is supposed to look for the range value on a column, find it, select the whole row and delete it. But I just can't put it to work. This is the part of the code, considering rng as Range and "budget_code" as the part of column A where the macro needs to look for the value:
I'd appreciate if someone could help me on this one.
Thanks a lot!
Code:
Sheets("budget").Select
Range("budget_code").Find(What:="rng.Value", After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
xlNext, MatchCase:=False, SearchFormat:=False).Activate
rng.EntireRow.Delete
I'd appreciate if someone could help me on this one.
Thanks a lot!