View Single Post
 
Old 06-07-2016, 01:41 AM
Daniel Arbeit Daniel Arbeit is offline Windows 7 64bit Office 2010 64bit
Novice
 
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