#1
|
|||
|
|||
Delete Blank Rows (Cyrillic Text in Spreadsheet )
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 |
#2
|
||||
|
||||
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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Count rows and add blank rows accordingly | Hoochtheseal | Word VBA | 1 | 01-29-2013 09:23 PM |
Delete all rows but the last. | elky1967 | Word VBA | 14 | 09-21-2012 05:27 AM |
Macro to conditionally delete rows | Steve_D | Excel | 2 | 08-24-2012 09:37 PM |
Macro to delete rows with all empty cells | ubns | Excel Programming | 2 | 08-14-2012 02:01 AM |
How to remove blank rows from a specified range? | Learner7 | Excel | 1 | 04-19-2011 02:45 AM |