JournalofAccountancy

Calculating double-declining balance depreciation for tax purposes in Excel

Q. I was excited to see the article about ways to calculate depreciation in Excel, especially when I saw one of them was double-declining balance (DDB). As tax professionals, we’re always trying to ...
Houston Chronicle

How to Use Tab Names as Variables in Excel

When you type data into an Excel workbook, the sheet's name appears in a tab at the bottom of the application window. When you edit the page code, the name isn't always so obvious. Although the Visual ...
TechRepublic

How to use VBA to change the active cell color in an Excel sheet

How to use VBA to change the active cell color in an Excel sheet Your email has been sent Image: PixieMe/Shutterstock Must-read Windows coverage CrowdStrike Outage Disrupts Microsoft Systems Worldwide ...
TechRepublic

10 ways to reference Excel workbooks and sheets using VBA

10 ways to reference Excel workbooks and sheets using VBA Your email has been sent Excel offers myriad options for referring to workbooks and sheets in your VBA code. See which methods make sense in ...