![]() |
|
#5
|
|||
|
|||
|
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("D2 9") 'COMMENT this means D2 : D9 without spaces, forum makes the smiley xDFor Each Cell In SomeRange If (Cell.Value = "") Then Cell.ClearContents Next End Sub |
|
|
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 Pane
|
windseaker | Word | 2 | 04-25-2014 10:34 AM |
| Navigation Pane | savo | Word | 2 | 04-17-2013 07:14 AM |
too much Navigation
|
eNGiNe | Word | 5 | 02-06-2012 12:58 PM |