Mr Excel & excelisfun Trick 37: Evalualte Text Math VBA, Excel 4 Macro Function, MoreFunc add-in?

Hi,
I saw EXCELISFUN TRICK 369. I need to do something similar. I tried to follow his code and couldn't. Then I tried copying it and growing his records and still couldn't get it to work.

What I am trying to do is on the first list use an inventory list. Which could be about 2000 - 5000 records or maybe double that (not sure how big of a list I could use in Excel). But lets say it is the max number (if someone could tell me that number I would be most appreciative).

I then will load a second list, or would load a list into second column. I then want the difference (what is missing) from the second list to appear in the third list. If it can give me the row of where it is in the first list that would be great (not a problem if you can't). I just don't know why the code from that video is not working any help would be greatly aprreciated?

Thanks,

Peter Fraga
(fragapete@hotmail.com)

Hi All,

I was setting up a spreadsheet that was based on the following vid:
http://www.youtube.com/user/ExcelIsF...14/tqCEY5YMyqw

Dynamic sub tables based on a master sheet array formula

The formula in question is:
=IF(ROWS(A$7:A7)>$E$1,"",INDEX('2010Corn'!A$4:A$17,SMALL(IF(Table2[From]=$B$1,ROW(Table2[From])-ROW('2010Corn'!$H$4)+1),ROWS(A$7:A7))))

B1 is the customer I'm looking for, E1 is the count for the customer and the master page is 2010Corn. I have 20 sheets looking to this master page for data. It works great, except for an issue when adding a new line in the master table.

What is happening is when I get to the end of a row, I tab to enter a new line in the table. It takes up to a minute for the cell to change color and for me to regain control of the computer.

I have run a performance trace and while the computer is locked, one of the CPU core's is pegged for the whole time with a processor que of up to 10 items at a time.

My question is...does anyone have any hints how to optimize this formula?

Thanks
Tony

Hi,

I have this problem with the morefunc add in.
I have this workbook which 2 of the worksheets requires function from the morefunc add in (indirect.ext).
I created them and they worked. But after i save them then reopen the work book again the #ref error appear for one of the worksheet but the other still works.
Is there anyone who have encounter the same problem and the answer to it?

Thanks!

Just This Video For Fun

http://www.youtube.com/watch?v=0VvjrldlqI0

math trick

column a column b
numbers reuslts 10 0 13 0 19 15 23 15 32 30 27 15 40 30 70 65 I'd like to say if number between 15 and it's multiplication put the the multiplication numbe

10 between 0 -15 put 0
13 between 0 -15 put 0
19 between 15 -30 put 15
23between 15 -30 put 15
32between 30 -45 put 30

and so on
for any number

i'm working until 250,000

thanks

Hello,

I'm having an interesting yet seemingly easy to fix problem in an
Excel Addin that I have been developing. Within the Addin, I save the
current file as a temp file, and then I save it back to it's original
path. I also do the same thing in Microsoft Word. In Excel, I am asked
if I would like to overwrite the original file, whereas in Micrsoft
Word, the save takes place without any dialogs. I tried setting the
AlertBeforeOverwriting property of the excelApplication to false, but
it has no effect. Any ideas on this problem would be greatly
appreciated.

Thank You,
Rob Heinen

Here is the code:

excelApplication.AlertBeforeOverwriting = false;

excelApplication.ActiveWorkbook.SaveAs( tempPath, extension,
missing, missing, missing, missing,
XlSaveAsAccessMode.xlShared,
missing, missing, missing, missing, missing );

//resave as the original
excelApplication.ActiveWorkbook.SaveAs( origPath, extension,
missing, missing, missing, missing,
Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, missing,
missing, missing, missing, missing );

Hi,

When I write the following in cell A1, =1&")", I get

1)

in cell A1.

What formula should I write in cell A2 so that I can get,

2)

in cell A2.

I tried the following in cell A2, =a1 + 1, but I get an error.

Can anyone help me find the correct formula.

is there an easy way to do this??? I am trying to convert the RATE() function to a normal math formula, so I can calculate it within another program... Here is the example I am trying to convert to normal math B1 is the function.

Microsoft Excel - Book1 ___Running: xl2002 XP : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout B1 B6 =
A B C D 1 Interest Rate 7.00% 2 3 Total Interest 279,017.80 4 # Years in Loan 30 5 # Payments / Year 12 6 Total Payments 360 7 Beginning Principal 200,000.00 8 Ending Balance 0 Sheet2

I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget to
type in an = sign first, an it gives me an error message. Is there a
setting to turn that off, so I can type in 44 + 66 and it gives me an
answer.

I often use excel as a fancy calculator. But often I forget to start the
calculator with the = sign. So if I want to add 44 + 66, I forget to
type in an = sign first, an it gives me an error message. Is there a
setting to turn that off, so I can type in 44 + 66 and it gives me an
answer.