Related:

- Formatting macro
- Spell number in excel without macro - Guide
- How to 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

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