Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Clear Cell Contents
I am trying to write this into my current macro where I clear the cells that
don't contain the letters "RO" in the below range. Range("B4:BQ20").Select Any help is greatly appreciated. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Clear Cell Contents
One way...
Sub ClearStuff() Dim rng As Range For Each rng In Range("B4:BQ20") If InStr(UCase(rng.Value), "RO") = 0 Then _ rng.ClearContents Next rng End Sub -- HTH... Jim Thomlinson "Frank" wrote: I am trying to write this into my current macro where I clear the cells that don't contain the letters "RO" in the below range. Range("B4:BQ20").Select Any help is greatly appreciated. Thank you |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Clear Cell Contents
Jim, Thank you, it works well.
"Jim Thomlinson" wrote: One way... Sub ClearStuff() Dim rng As Range For Each rng In Range("B4:BQ20") If InStr(UCase(rng.Value), "RO") = 0 Then _ rng.ClearContents Next rng End Sub -- HTH... Jim Thomlinson "Frank" wrote: I am trying to write this into my current macro where I clear the cells that don't contain the letters "RO" in the below range. Range("B4:BQ20").Select Any help is greatly appreciated. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to clear range contents when cell contents are changed by us | Excel Programming | |||
Clear Contents Macro | Excel Programming | |||
Need macro to clear contents | Excel Programming | |||
VBA Macro to Clear Named Cell Contents | Excel Programming | |||
MACRO TO CLEAR CELL CONTENTS | Excel Programming |