Change populated cell names via macro

[TJM]

I have an Excel macro that formats a page for me. I want to add a step in my macro that basically says 'for any cell in column C that says TRUE, change to YES' and 'for any cell in column C that says FALSE, change to NO'.

Can anyone tell me what the macro would be to read any populated cell in column C and make these changes?

[stevebriz]

here is one way

Sub macro1()

For Each cell In Sheets("Sheet1").Range("C1", Range("C65536").End(xlUp).Address)
Select Case cell.Value
Case True
cell.Value = "YES'"

Case False
cell.Value = "NO'"
Case Else
End Select

Next cell
End Sub

Please Login or Register  to view this content.

[mudraker]

another option

Columns("C:C").Select
Selection.Replace What:="True", Replacement:="YES", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Selection.Replace What:="False", Replacement:="NO", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False