farshad Posted September 10, 2003 Posted September 10, 2003 I am using vb.net to populate an excel sheet fine... But when using: .ActiveCell.FormulaR1C1 = "=MIN(C" & intFirstYellow & ":C" & intLastYellow & ")" to place a formula i.e. =MIN(C5:C7) does not work accurately, it place =MIN($E:$F) instead. Can you see why? Thanks Quote Farshad
techmanbd Posted September 16, 2003 Posted September 16, 2003 Is intFirstYellow an integer? if so you are trying to combine an integer with a string. Try .ActiveCell.FormulaR1C1 = "=MIN(C" & str(intFirstYellow) & ":C" & str(intLastYellow) & ")" Quote Live as if you were to die tomorrow. Learn as if you were to live forever. Gandhi
AndreRyan Posted September 17, 2003 Posted September 17, 2003 Use native .Net rather than the compadibility functions: .ActiveCell.FormulaR1C1 = "=MIN(C" & intFirstYellow.ToString & ":C" & intLastYellow.ToString & ")" Native functions are supposed to be faster than the compatiblility ones Quote .Net allows software to be written for any version of Windows and not break like Unmanaged applications unless using Unmanaged procedures like APIs. If your program uses large amounts of memory but releases it when something else needs it, then what's the problem?
techmanbd Posted September 17, 2003 Posted September 17, 2003 AH ok, I am learning .net. I just got it a few weeks ago. Quote Live as if you were to die tomorrow. Learn as if you were to live forever. Gandhi
Recommended Posts