What is the ActiveCell.Value of a wrapped cell

[Kanine]

Excel experts,

I am new to the forum and this is my first post. I have read the rules and guidelines, and I will do my best to follow them. I apologize if break any rules.

I am working on a macro that searches for certain cell values. I am struggling with the correct syntax of the cell value if wrap text is on. I have searched high and low for this but can't seem to word my searches correctly.

My code is:

If ActiveCell.Value = "Example cell value"

Where "Example cell value" is in a wrapped cell. "Example" is on the first line and "cell value" is on the second line. I have tried several underscore combinations but none have worked.

Any help is greatly appreciated.

 

[Rick Rothstein]

Thanks Rick Rothstein. I tried your code and it works perfectly...except for those two cells for some reason.

What do you mean by "except for those two cells"? There is no direct test for those two cells so I don't see what can be failing. All your headers are on Row 1, correct?

 

[Kanine]

Well, I rebuilt the workbook from scratch. Everything works exactly how I imagined it should. Thank you all for not only helping me fix the issue, but for also improving the code.

FYI, for the two columns giving me a fuss earlier, I changed the value to only be one line visually, and it worked. I then changed it to what it was before the rebuild, and it wouldn't work for the two cells. I ended up changing it back to the one line value and I'm sticking with that. I can't explain it.

 

[Kanine]

What do you mean by "except for those two cells"? There is no direct test for those two cells so I don't see what can be failing. All your headers are on Row 1, correct?

I can't explain it. All headers are on row 1 so it should have worked. Nothing was failing, except for the error message not showing up. It just wasn't triggering the error message when either of those two cells were the active cell. I was using the code:

ActiveCell.Row = 1 Or ActiveCell.Column <> 2

I'm pretty convinced there was something wrong with that workbook because the rebuild works much faster when I save it, along with the macro working as it should.