![]() |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
|
|
#1
|
|||
|
|||
|
Code:
Sub Test()
Dim rng As Range
Dim cel As Range
Set rng = Range("A1:Z100") '<-- change range as required.
Application.ScreenUpdating = False
For Each cel In rng
If cel.Value = "$-" Then cel.ClearContents
Next cel
Application.ScreenUpdating = True
End Sub
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Data from a specific row in a spread sheet into a form
|
JohnnySTI | Excel Programming | 13 | 01-24-2018 01:20 PM |
Simple Spread Sheet
|
TThomas | Excel | 1 | 04-07-2016 09:01 PM |
Using combobox to pass data from an Excel spread sheet to text boxes on userform
|
Stewie840 | Word VBA | 14 | 12-17-2015 10:13 PM |
| Copy data from certain Cells in new sheet | zain_shaikh | Excel Programming | 1 | 02-11-2015 07:35 PM |
| Condensing a spread sheet | hawkeyefxr | Excel | 4 | 08-22-2012 05:17 AM |