I am working on a project which requires deletion of excel values of a particular column and update with new value. Basically its similar what we do manually in excel by finding an existing value and replace all with a new value. So what I need is how can I replace with the new value coz I dont want to search for the existing value as I want to delete the cell values of a particular column (Delete) and paste the new value in all the cells where the old data has been deleted from. But I have to keep track of the number of values that it will delete , should match with the no of pasting of the new value. This is something I need as the excel contains multiple table data , values of a particular table , separated by a blank row. so once the blank cell reaches, it should stop deleting and paste the new value exactly the same no of times that it has deleted from the column. Please do let me know of any clue or in case you have any doubt of my requirement.