Related:
- Formatting macro
- Spell number in excel without macro - Guide
- Clear formatting in excel - Guide
- Phone formatting software for pc - Download - File management
- Macro excel download - Download - Spreadsheets
- Excel macro to create new sheet based on value in cells - Guide
2 responses
Hello,
Thank you matey!
You are doing an amazing job!
One more question !! Is there any particular book that can help me learn Macro from basic level.
Thank you!
Helper :)
Thank you matey!
You are doing an amazing job!
One more question !! Is there any particular book that can help me learn Macro from basic level.
Thank you!
Helper :)
Private Sub ChangeColor()
Dim f As Range
Dim wrd As Boolean
wrd = "False"
For Each f In Range("B8:BZ616")
If f.Value = wrd Then
f.Select
With Selection.Font
.ColorIndex = 50
End With
End If
Next f
End Sub
Dim f As Range
Dim wrd As Boolean
wrd = "False"
For Each f In Range("B8:BZ616")
If f.Value = wrd Then
f.Select
With Selection.Font
.ColorIndex = 50
End With
End If
Next f
End Sub
In my first example, "wrd" was declared as Boolean which returns an integer value.
Try this code instead. Hopefully, you won't get an error this time.
Private Sub ChangeColor()
Dim f As Range
Dim wrd As String
wrd = "FALSE"
For Each f In Range("B8:BZ616")
If f.Value = wrd Then
f.Select
With Selection.Font
.ColorIndex = 50
End With
End If
Next f
End Sub
Try this code instead. Hopefully, you won't get an error this time.
Private Sub ChangeColor()
Dim f As Range
Dim wrd As String
wrd = "FALSE"
For Each f In Range("B8:BZ616")
If f.Value = wrd Then
f.Select
With Selection.Font
.ColorIndex = 50
End With
End If
Next f
End Sub
Feb 6, 2009 at 01:30 PM
I started with the book Excel VBA for Dummies, and then I moved on to
Excel Programming, 2nd Edition. By Jinjer Simon.
www.wiley.com