I posted last week & was delighted to be able to delete blank cells in excel using these instructions: http://chandoo.org/wp/2010/01/26/delete-blank-rows-excel/
However, after manipulating data differently (using an 'if then' to create new values based on existing one, excel now tells me 'no cells are found' in a pop-up. I don't see anything in the cells and copied and pasted only values.
However, after manipulating data differently (using an 'if then' to create new values based on existing one, excel now tells me 'no cells are found' in a pop-up. I don't see anything in the cells and copied and pasted only values.