Hello,

I think my request is a simple one, but I just can't figure it out. I've looked at several to examples but all seem to want to delete the entire row. I just want to delete the cells in a row within a certain range. Here is my question and example.

I have a range called "Team_Ambrosio" that goes from Column A to Column J. The height is variable but I don't think that should make a difference. I need VBA that, when executed, will delete the row of cells within "Team_Ambrosio" when Column A = "NLE". It's really that simple but I'm not sure how to write it so that it does not delete the entire row across the whole worksheet. I just want the row deleted within the range "Team_Ambrosio". I then want the cells to shift up. Any ideas? Thanks!