| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro line too long?
I went to program this formula in my macro, it did not work. I am thinking
that it is too long to accept it. I even did it manually while the macro was recording and it didn't record anything. Wonder why? The actual formula does work, but want it to work in my macro. Please help. ActiveCell.FormulaR1C1 = _ "=IF(ISERROR(RC[-1]),RC[2],INDEX('[Charge Type Translation.xls]Sheet1'!R2C1:R24C1,MAX(INDEX(('[Charge Type Translation.xls]Sheet1'!R2C2:R24C27=RC[3])*ROW('[Charge Type Translation.xls]Sheet1'!R2C2:R24C27),))-ROW('[Charge Type Translation.xls]Sheet1'!R1C2))" MrRJ |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - How do I fit 2 lines of text in one cell, vs a long line? | Excel Discussion (Misc queries) | |||
| Breaking up long line of code doesn't work | Excel Programming | |||
| one VERY LONG line | Excel Discussion (Misc queries) | |||
| How do I get the text to continue on the next line when its long | Excel Discussion (Misc queries) | |||
| Splitting Long Line | Excel Programming | |||
Threaded Mode
