Explanation on VBA Replace syntax

[Greemo]

Hello,

I'm using this following lines of code in excel vba 2013:

  Application.FindFormat.Clear
  Application.FindFormat.Font.Strikethrough = True
  Range("Todo, todoest, tododd").Replace "*", "", SearchFormat:=True
  Application.FindFormat.Clear

How does the * character work in this? I believe it's assuming the "What" position for the replace syntax? Is that right?

Thanks in advance.

Greemo

 

[NeonRedSharpie]

Hello,

I'm using this following lines of code in excel vba 2013:

  Application.FindFormat.Clear
  Application.FindFormat.Font.Strikethrough = True
  Range("Todo, todoest, tododd").Replace "*", "", SearchFormat:=True
  Application.FindFormat.Clear

How does the * character work in this? I believe it's assuming the "What" position for the replace syntax? Is that right?

Thanks in advance.

Greemo

Basically the macro is replacing all "*" with nothing "" for anything with a strike through.

 

[Greemo]

I don't understand how VBA is reading the *. Does this mean everything?

Greemo

 

[NeonRedSharpie]

I don't understand how VBA is reading the *. Does this mean everything?

Greemo

Yes. It means replace ANY TEXT FOUND IN THE CELL.

 

[Greemo]

Yes. It means replace ANY TEXT FOUND IN THE CELL.

Ok thank you.

Would you know how I would apply bold to the search results (all the cells with strikethrough formatting) before the procedure replaces them with "" ?

Greemo