Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I need a macro that can find the error value "#I/T" in the range A1:D10 and clear the contents. I tried this one below, but it didn't work, so I hope someone can correct it or write a complete different macro doing the same thing. Sub CheckCell() Dim rCell As Range Dim sMyString As String Set rCell = Range("A1:D10") If IsError(rCell.Value) Then Cell.ClearContents End If End Sub Regards, Kaj Pedersen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Error dialog box meaning and how to find error | Excel Worksheet Functions | |||
Find and Replace - delete the remainder of the text in the cell after my Find | Excel Programming | |||
help with this error-Compile error: cant find project or library | Excel Discussion (Misc queries) | |||
find and delete duplicate entries in two columns or find and prin. | Excel Programming | |||
find and delete text, find a 10-digit number and put it in a textbox | Excel Programming |