![]() |
|
|
|
#1
|
||||
|
||||
|
Hi umesh,
Change: If StrTmp = "" Then .Delete to: If StrTmp = "" And InStr(Rng.Text, "0") > 0 Then .Delete PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Macro to Table Style | ubns | Word VBA | 1 | 04-16-2012 05:01 AM |
| Help with pivot table macro | ejima | Excel Programming | 2 | 02-16-2012 03:45 PM |
| Sort table using macro | saslotteroy | Word VBA | 2 | 09-15-2011 02:41 PM |
Eliminating zeros, null values and negatives in a column
|
jannie | Excel | 1 | 06-22-2011 07:03 PM |
How Do I Replace Nulls With Zeros?
|
deekadelic | Excel | 1 | 08-11-2006 09:52 PM |