quotes

Can anyone tell me why this doesn't work? I assume it has to do with the double quotes. Tot is defined as a string. new row is defined as an integer. Tot = "=IF(AND($E" & newrow & "=" - ",$F" & newrow & "=" - ")," - ",$D" & newrow & "*$G" & newrow & ")" Thanks!

Hi, I have a general question. Is it possible that Excel users on serveral computers in one local area network can see permanently updated stock quotes that are provide by one Bloomberg Professional terminal in the same network? The idea behind is that several users can open an Excel file that...

I'd like to enter in an equation such as this into a cell: {=SUM(IF(LEFT(D8:D17,3)="130",E8:E17,0))} in VBA. There are two issues. First, when I build up a string, I normally can't have quotes "". In php, this is simple, use single quotes instead, such as cell.formula =...

This is the sort of thing I was sure had been covered here a thousand times, but I'll be damned if I can find a simple solution. I'm using Excel 2007 and trying to save a simple CSV file, but it needs to have quotes around every value (the system I'm going to be importing the file into...

Hello there, I want to create a form in excel for gathering client information, and spitting out quotes using unique contract numbers AND then collecting that data in a spreadsheet. I would like the form to open up blank with the next contract number in sequence, but then if I click the record...