Runtime error '13'

[robotball]

I'm not sure if this is possible, which is probably why I continue to get this error message and my macro does not work correctly.

I have a macro on a column which when I type in the letters "LB" (no quotes) the macro changes the font color to bright green. For the longest time I have been manually entering the letters "LB", but I now discovered that other data in the row can place the "LB". So I created a formula like this:

Please Login or Register  to view this content.

The problem is when I copy and paste the formula to all rows I get a runtime error on the macro, error #13. In addition only some of the rows work correctly. All of them from the formula perspective have LB properly inserted, but they are not highlighted.

What am I doing wrong?

Thanks.

[Leith Ross]

Hello Rootball,

You need to post your macro to get an answer to your question.

Sincerely,
Leith Ross

[robotball]

Here is the macro

Please Login or Register  to view this content.

[Leith Ross]

Hello Rootball,

When writing macros that are to be used as User Defined Functions (UDF), there are a few rules.

A UDF can...
1) only return a value to the cell that calls it.

A UDF can't...
2) modify or place a value in another cell.
3) modify the cell's format properties

Sincerely,
Leith Ross