Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 968
Default FormulaArray..... HELP !!!

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/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re : Excel FormulaArray Copy-and-Paste via VBA [email protected] Excel Discussion (Misc queries) 0 May 5th 08 09:26 AM
FormulaArray Troy Excel Worksheet Functions 1 November 23rd 04 03:42 PM
FormulaArray with existing cell Michael Singmin Excel Programming 4 March 6th 04 03:55 PM
FormulaArray UK[_2_] Excel Programming 2 February 23rd 04 05:39 PM
FormulaArray and Formula prinicples Niklas[_2_] Excel Programming 2 July 18th 03 05:30 PM


All times are GMT +1. The time now is 12:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"