Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-29-2013, 08:16 AM
dozd dozd is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Jan 2013
Posts: 1
dozd is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 02-22-2013, 03:24 AM
macropod's Avatar
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,801
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

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
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:58 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft