VBA reference first row in active column

[upplepop]

I am trying to write an If-Then statement that performs an action if the header row of the column of the active cell contains a plus (+) sign. For example, if the active cell is C23, it would check if C1 contained a plus sign.

I feel like I'm pretty close with the following code, but it's not working:

If InStr(Cells((ActiveCell.Column), 1), "+") <> 0 Then

Thanks in advance!

 

[njimack]

You have the arguments the wrong way round...

If Instr(Cells(1, ActiveCell.Row),"+", 1) > 0 Then

 

[Marcelo Branco]

Welcome to Mr Excel forum

Try

If InStr(Cells(1, ActiveCell.Column), "+") Then

Hope this helps

M.

 

[upplepop]

That worked Marcelo!
Thanks for the help.

 

[Marcelo Branco]

You are welcome. Thanks for the feedback.

M.