Like Dana, I seem to remember a bypass existed to the max 256 character
formula problem but I cant find it ...
some ideas that may help:
- use short names for the ranges.
- use absolute rather than relative because its shorter in R1C1 mode.
- use short sheet names (rename afterwards if required)
regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm
"Pierre " wrote in message
...
Thanks a lot William.
So basicely, I am stuck !!!
#?!£$%# Excel !!!
It is very annoying !
They should focus on this kind of problem instead of adding some new
fancy functionalities !!!!

---
Message posted from http://www.ExcelForum.com/