| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
empty vs. "" vs. Null vs. Nothing vs. not Used vs. Argggh
Brilliant! Looks perfect! Thanks!
On Sun, 1 May 2005 12:16:23 -0700, "Tim Zych" wrote: With ActiveSheet.UsedRange .Value = .Value End With will clear out the blank-looking gunk. Can take a while on a large range. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperion Essbase Excel Add-in - returning text ("0") for null valu | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| How to write parameter query with "or is null" criteria | New Users to Excel | |||
| cells formatted to tick when text value "Y" if or null if "N" | Excel Discussion (Misc queries) | |||
| "IF"- "THEN" type Formula based on Null value | Excel Worksheet Functions | |||
![Wild Bill[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
