Only for questions on programming against Excel objects or files, or complex formula development.
I have a column of numbers of over 500 rows. I need to use VBA to check if variable X matches …
excel vba matchingHow does one reorder series used to create a chart in Excel? For example, I go to the chart, right …
excel charts excel-2011I would like to know if we can find out the Color of the CELL with the help of any …
excel worksheet-functionI created a macro for a file and first it was working fine, but today I've been opening and restarting …
excel excel-2010 vbaI am using a While...Wend loop of VBA. Dim count as Integer While True count=count+1 If count = 10 Then …
excel vba while-loopIt seems Excel 2013 doesn't read CSV files correctly (Excel 2010 does). Every time I open .csv files, all my data are …
excel csv office-2013I've an Excel File Arm_id DSPName DSPCode HubCode PinCode PPTL 1 JaVAS 01 AGR 282001 1,2 2 JaVAS 01 AGR 282002 3,4 3 JaVAS 01 AGR 282003 5,6 I want to …
python excel xlrdDoes anyone know the formula to find the value of the last non-empty cell in a column, in Microsoft Excel?
excel worksheet-functionIs it possible to declare variables in Excel cells and use them as parameters for formulas in other cells? For …
excel excel-formula