Shell Function in VBA
Shell Function in VBA can run executable program and returns a Variant (Double) representing the program's task ID if successful otherwise, it returns zero. Syntax Shell(pathname, [ windowstyle ]) pathname:
Tag: Excel Tips
Goal Seek in Excel using VBA: Find Minimum Sales to Hit a Target
Goal Seek in Excel using VBA lets you answer a "how much do I need?" question with one button click instead of opening the What-If Analysis dialog every time. In
Subtotal Feature in Excel: Group, Sum and Outline Your Data
The Subtotal feature in Excel adds a total after every group in a sorted list, adds a grand total at the bottom and builds an outline, so you can collapse
Loop Through Worksheets, Sheets and Chart Sheets in Excel VBA
To loop through worksheets in VBA you first need to know which kind of sheet you are looping over, because Excel has two: worksheets with cells, and chart sheets that
Create Auto Table of Contents in Excel Workbook (VBA Macro)
When you create an auto table of contents in Excel for a workbook, you get a single index sheet that lists every worksheet with a clickable link, so nobody has
Auto Bullet Points in Excel with Custom Number Formatting
Auto bullet points in Excel are easy once you know the trick. Word, Outlook and PowerPoint have a Bullets button, but Excel doesn't, so most people type a symbol at
Apply the Same Format to Other Charts in Excel (2 Quick Ways)
Want to apply the same format to other charts in Excel without redoing every click? When you build a dashboard, you usually style one chart carefully (fonts, data labels, gradient
Show Hidden Data on an Excel Chart (Hidden and Collapsed Rows)
If you want to show hidden data on an Excel chart, there is one checkbox you need to know about. By default, an Excel chart only plots the cells you
Rearrange Columns in Excel Using Data Sorting (3 Quick Ways)
To rearrange columns in Excel without endless cut and paste, let the Sort command do the work. Most people only ever sort rows from top to bottom, but Excel can
Dynamic Number Format in Excel for Millions and Thousands
A dynamic number format in Excel shows big numbers as 1.2K or 3.5M automatically, so your tables and charts stay readable without changing a single value. In this tutorial you