I have this code which deletes cells by the entire column. Initally i thought it would be of good use, later i realised that if i do so, the useful data on that same column would get deleted too . Hence i need a code which allows me to delete any range of cells be it rows or columns at my own convenience I have this code which deletes cells by the ent