Quote Originally Posted by firefytr
Hi,

Not sure if I understand what you mean, but maybe adding a check to it ... ??

If cell.Value <> "" Then
cell.Offset(0, -1).Value = "=VLOOKUP(RC[1],Language,3,FALSE)"
cell.Offset(0, -2).Value = "=VLOOKUP(RC[2],Language,2,FALSE)"
End If
(And I added the VBA tags to your post; see what it does to the code? Thanks to Mark007 for that!)
Thanks for the reply



If I understand that code right it will only add the formula if the target cell is blank what I am looking for is if the target cell is Blank (or becomes blank if data is removed from the target cell) then the formulas are removed from the ranges in the offset.




Let me try to explain a little more this sheet has a lot of information entered and removed every day and after data is removed the formulas stay because this code adds them (and takes up a lot of space). What I would like is if the data is removed then remove the formulas from the ranges that this code adds them too cell.[vba] Offset(0, -2).Value = "=VLOOKUP(RC[2],Language,2,FALSE)"[/VBA]



thanks for the tip on the vba tags! and let me know if you need more information