![]() |
|
|
Thread Tools | Display Modes |
#3
|
|||
|
|||
![]() 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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
JohnnySTI | Excel Programming | 13 | 01-24-2018 01:20 PM |
![]() |
TThomas | Excel | 1 | 04-07-2016 09:01 PM |
![]() |
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 |