Formula limit work around?

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I have a user who is using a formula which has reached the 1024 limit. Can
this formula be split up into two cells? Or can I use VBA to re-engineer the
formula?

Any formulas in VBA would be appreciated or any other suggested work
arounds.

Jeff
 
Hi

You could possibly take parts of the formula and enter them as defined
names with Insert>Name>Define.
Then refer to those names within the rest of the formula.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA 1
SUM / COUNT formula 3
Conditional formatting based on formula cell 6
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
Excel 2010 for PC doesnt work on Excel Mac 2011. 11
error in formula 5
Excel 2013 vlookup to different workbooks not working 5
Building closed workbook file path within an Index Function 6

Back
Top