Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #5  
Old 06-07-2016, 01:41 AM
Daniel Arbeit Daniel Arbeit is offline Navigation Strg+Arrowkeys Windows 7 64bit Navigation Strg+Arrowkeys Office 2010 64bit
Novice
Navigation Strg+Arrowkeys
 
Join Date: Jun 2016
Posts: 5
Daniel Arbeit is on a distinguished road
Default

Xor thank's for the hint, got it now. The cells are not truely empty and there is no way to do this by a formular.

You can do it by VBA however:

Sub Empty_Cells()
Dim SomeRange As Range
Set SomeRange = Range("D29") 'COMMENT this means D2 : D9 without spaces, forum makes the smiley xD
For Each Cell In SomeRange
If (Cell.Value = "") Then Cell.ClearContents
Next
End Sub
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Navigation pane BeverlyB Word 1 09-29-2014 12:10 PM
Navigation pane BeverlyB Word 2 09-18-2014 12:01 PM
Navigation Strg+Arrowkeys Navigation Pane windseaker Word 2 04-25-2014 10:34 AM
Navigation Pane savo Word 2 04-17-2013 07:14 AM
Navigation Strg+Arrowkeys too much Navigation eNGiNe Word 5 02-06-2012 12:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:51 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft