| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear Contents Of Cell If Value = 0 or Error
I posted last week on this problem I am trying to solve.
Sub stantiate() Dim myRange As Range Set myRange = Range("C10:d1000") For Each c In myRange If c.Value = 0 Then c.Value = "" End If Next End Sub The code gets hung up at: If c.Value = 0 Then the cell value could be #N/A or some other "errors". Could this be the reason the code gets hung up ? If so, is there a way to resolve the problem ? Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Clear Contents of Adjacent Cell on Conditional Basis | Excel Discussion (Misc queries) | |||
| Is there a formula to clear the contents of a specific cell? | Excel Worksheet Functions | |||
| How do I clear the contents of one cell from another cell? | Excel Worksheet Functions | |||
| vb to clear cell contents | New Users to Excel | |||
| Clear cell contents with a button | Excel Worksheet Functions | |||
Threaded Mode
