I know that using .Select in Excel VBA is a bad habit, but I don't know how to avoid using it. Why […]

Is there a built-in way to URL encode strings in Excel VBA, or do I need to manually code this functionality? Before […]

The idMSO is used to uniquely identify a built-in control, tab, command, etc. Use this to interact with built-in objects. The idMso […]

Use API method to open url with default browser Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, […]

Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot […]

Nightingale Rose Diagram is the most famous statistical diagram. It's a form of the Pie Chart now known as the Polar Area […]

How To Remove All Hyperlinks In Excel 2003 At Once If you want to remove all hyperlinks in a worksheet at once, you […]