How to Debug-Run Time error- 1004 Application-Defined or object defined error

I have a macro with a series of the same commands.
They all work except this one. I don't understand what is wrong. It just highlights the whole line.
I've obviously change the data to look generic.

At first I thought it was the &_ because that is a break in the line in VB. I deleted that and it still didn't work.

Any ideas or suggestions?
I have about 10 other lines like that and they work fine.

Please Login or Register  to view this content.

Or
Enter the formula in a cell
Select the cell with the formula
Developer - Record Macro - OK (for macro name)
F2 - Enter
Right click on the active Sheet Tab
Select View Code
You'll see the formula in the macro you just OK'd

GC Excel's way is shorter though.

Thanks for your responses.

This is actually a recorded macro.
That's what is confusing me.
I clicked record macro then created the formula and selected the entire column and copied the formula into that column.

I even tried recording the formula and clicking fill down and I got the same error.

I did a similar formula in columns before and after this one and they are fine.

I figured it out.
There was a "IF(Left(" deleted after the "&_". once I put the "IF(LEFT(" back in it worked!