| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Clearing Non-numerical CellCvalues
Hello, I have a range (D9:DP496) that contains numerical values and
text. I want to clear all the cells that do not have numerical values. I attempted it below but failed miserably. As you can see I am a new learner to VBA. Can you help? If Workbooks("Regional Banks.xls").Worksheets("Regional Banks").Range("D9:DP496") < Format ("#") Then Cells.Value = "" End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I resort numerical info into numerical order | Excel Worksheet Functions | |||
| Clearing cells without clearing formulas | Excel Discussion (Misc queries) | |||
| Clearing A Row | Excel Programming | |||
| Clearing #N/A's in one go? | Excel Worksheet Functions | |||
| Clearing #VALUE | Excel Worksheet Functions | |||
Threaded Mode
