"Unable to record"

[schnabs]

When I use the record macro function in Excel, and I try to record this in a cell

=IF(AND(MATCH(MAX(
OFFSET($K$1,MATCH(J2,$J$2:$J$5000,0),0,COUNTIF($J$2:$J$5000,J2),1)),
OFFSET($K$1,MATCH(J2,$J$2:$J$5000,0),0,COUNTIF($J$2:$J$5000,J2),1),0)<=COUNTIF($J$2:J2,J2),(E2<>0)),E2,IF(A2<>"","Total",0))

It throws an unable to record error message. I've searched around online and only found that Excel limits Macros to under 255 characters per cell, but this is 213. Anyone have any ideas?
Thanks

 

[AnotherHiggins]

What version of Excel are you running?


[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[schnabs]

Excel 2003

 

[schnabs]

Nevermind I've figured it out. Thanks anyways.

 

[combo]

The length of your formula in R1C1 notation (used by recorder) is 274. Instead, you can copy this formula, adjust quotation marks and use 'Formula' property with processed string.

combo