PC Review


Reply
Thread Tools Rate Thread

character limit in formula

 
 
=?Utf-8?B?RGFu?=
Guest
Posts: n/a
 
      27th Jun 2007
I am trying to assingn via vba a formula that is more than 255 character.
using: range("A1"). formula = "bla blaa...."
is there a way around the 255 character limitation
 
Reply With Quote
 
 
 
 
=?Utf-8?B?SkxHV2hpeg==?=
Guest
Posts: n/a
 
      27th Jun 2007
We might be talking apples and oranges but I got this out of the Excel
specifications that is available in Excel help.

Length of cell contents (text) 32,767 characters. Only 1,024 display in a
cell; all 32,767 display in the formula bar

Maybe VBA is the problem.

"Dan" wrote:

> I am trying to assingn via vba a formula that is more than 255 character.
> using: range("A1"). formula = "bla blaa...."
> is there a way around the 255 character limitation

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Character limit dst393 via AccessMonster.com Microsoft Access VBA Modules 4 24th Aug 2006 03:20 PM
255 character limit =?Utf-8?B?Tm9haA==?= Microsoft Excel Programming 4 23rd Feb 2006 03:04 PM
Cell 255 character limit and formula =?Utf-8?B?RWFnbGVzTmVzdA==?= Microsoft Excel Worksheet Functions 6 27th Feb 2005 12:06 AM
Character limit singkit Microsoft Excel Worksheet Functions 2 5th May 2004 09:30 PM
Div's and character limit Powervision Microsoft ASP .NET 0 4th Dec 2003 08:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:53 PM.