Excel – Usage of Checkmark with formulas and custom formatting
Plenty of times, when I open some someones Excel files I see something as a check …
Excel – Usage of Checkmark with formulas and custom formatting Read more →
Plenty of times, when I open some someones Excel files I see something as a check …
Excel – Usage of Checkmark with formulas and custom formatting Read more →
When you work with professionally built VBA tool, sometimes logging your actions (or the actions of …
VBA – create a log sheet of Excel with specific actions Read more →
If you work as a VBA developer long enough, you may find quite interesting tasks to …
VBA – Merge horizontal cells with equal values in Excel Read more →
I the current article I will simply present how to save the results from a filtered …
VBA – Save text from filtered table in Excel in separate file Read more →
If you program with Excel and VBA, probably you have plenty of various functions, showing you …
VBA – Excel custom functions – Document Properties Read more →
With the current article I will simple present some easy code, transferring Chart (diagram) to a picture. …
Long long time ago, when I was building some Excel VBA spreadsheet tool for a leading …
VBA – Getting column name from number in Excel – Function Read more →
In this post I will simply show a few VBA tricks, for defining last used cell …
VBA – Defining last cells in row/column and size of spreadsheet Read more →
After the first article for custom excel formulas with VBA (here) I have decided to enlarge …