peltier tech utilities
Learn how to create Excel dashboards.

Categories

30 Excel Functions in 30 Days

Archives

Excel VBA: Switch Column Headings to Numbers

It's Friday, and your brain is almost full, but let's try to cram a little bit of Excel VBA in there before the weekend.

We've talked about the Excel Column Headings before, and seen how to change the Reference Style setting from R1C1 (Numbers) to A1 (Letters). That setting is pretty well hidden, and it's [...]

Related Posts Plugin for WordPress, Blogger...