Hi, I wanted to Delete Blank Rows in SHeet, and found this solution:



http://chandoo.org/wp/2010/01/26/del...nk-rows-excel/

It works fine but only if I use text with Latin Alphabet in spreadsheet. With Cyrillic text in spreadsheet it does not work. I receive error "No cells were found" when I try to select blank cells (CTRL+G ->Special->Blank-> OK)


Can anybody help me to use this solution with Cyrillic Alphabet?

thanks for understanding

Hi dozd,

Are you sure the cells are actually empty and don't contain spaces or hidden content (eg 0s hidden via formatting)?

If so, can you attach a document to a post with some representative data (delete anything sensitive)? You do this via the paperclip symbol on the 'Go Advanced' tab.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]