Top "Excel-2010" questions

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft.

Apache-POI: Unable to write to an existing workbook

I'm working on a project which needs to read an Excel Workbook, calls the necessary Web Services, and then takes …

java apache-poi excel-2010
Create macro to search Worksheet for list of strings and highlight the row

Can someone help me create a macro that will search an Excel worksheet for a list of 30 strings (e.g., …

excel excel-2010 string-search vba
Formula to conditional formatting text that contains value from another cell

I have a column A that contains a 1-4 word phrases in each cell. I also have 4 cells that contain 1 …

excel excel-formula excel-2010 conditional-formatting
How do I sum a named range of values that contains errors?

I have an Excel spreadsheet which imports data from another source that I need to run a calculation on. The …

excel worksheet-function excel-2010
Change chart font using VBA

How do I change the font of an Excel chart using VBA? If I manually select the chart, and record …

vba excel excel-2010 excel-charts
Getting ScriptControl to work with Excel 2010 x64

I am trying to use the solution given to this, however, whenever I try to run the most basic anything, …

vba excel com excel-2010 scriptcontrol
Edit SQL in Power Query

When I import data from Sql Server in Power Query, I can paste a query to be executed against the …

excel-2010 powerquery
Excel headers/footers won't change via VBA unless blank

Disclaimer: It's been a few years since I worked (a lot) with VBA, so this might be an issue caused …

vba excel excel-2010
Convert HEX to RGB in Excel

I have a column "HEX" and three columns "R", "G", and "B". How can I convert a HEX to RGB, …

excel excel-formula hex excel-2010 base
Excel 2010 - Count Unique values only in a SUBTOTAL cell

Info: Excel 2010 (no macros) Data Origns: MySQL Query / phpMyAdmin Server: Apache Code is run via: Server SQL Query (copy & …

excel excel-formula excel-2010 subtotal