Recent content by koye

As a matter of fact. You can do anything with Excel using C with the Microsoft Excel SDK. The performance gain compared to VBA is HUGE. http://msdn.microsoft.com/archive/default.asp?url=/archive/en-us/office97/html/SFEA6.asp

b) You can always define some VBA User Defined function to detect any changes on the cells that you're interested and Excel will trigger your UDF function when any of the monitoring cell changes. For example, you wan to monitor any changes in cells A1, B1, C1. Assuming that these cells are...