Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Harry Hunter   on Oct 19 In MS Office Category.

  
Question Answered By: Dinh Tran   on Oct 19

No, You will need to type the code in. type For then press F1 and look at the
help screen. look at the For each ... next

You will end up with something like (untested)
Option Explicit

Sub fixit()
Dim myrange As Range
Dim c As Range

Set myrange = ActiveSheet.Range("A1:Z24")

For Each c In myrange
If c.Interior.Color = vbWhite Then
c.Font.Bold = True
End If
Next c
End Sub

Share: 

 

This Question has 7 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Macro for One-Solution Puzzle Or get search suggestion and latest updates.


Tagged: