TechRepublic

Conditional formatting tricks: Sum values in Excel by cell color

Conditional formatting tricks: Sum values in Excel by cell color Your email has been sent When you think VBA code is your only hope, try combing built-it conditional formatting tools. You might just ...
TechRepublic

Office Q&A: How to stop Excel’s paste task from overwriting destination cell’s format

Office Q&A: How to stop Excel’s paste task from overwriting destination cell’s format Your email has been sent It's not easy to fool Excel, but with a few extra clicks, you can work around this odd ...
Ars Technica

VBA: Connection string results in "External table is not in the expected format"

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the most ...