#REF! error in column with vlookup after deleting cell referenced in the vlookup


New Member
I have to delete/clear the data in a certain worksheet range and paste new data in the same range. I'm using the Delete action then Copy and Paste Worksheet Range action in the MS Excel Extended VBO. In the same worksheet, there is a column with the vlookup formula referencing a cell which forms part of the range copied&pasted. After running the Delete action, the column with the vlookup formula gives the #REF! error. Can you help me to avoid the error in the vlookup column?
Last edited: