Microsoft Office Excel completes text entries that you start to type in a column of data — if the first few letters that […]

Convert String to Array In cell A1 there is a string separated by ",": A,1,b,2,Dx Now, how can I convert A1 to […]

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, […]

If you have some troubles with macro and projects explorer windows settings, after some bad manipulations. How to reset the VBE windows […]

For example, you have a 32-bit application (VBA, web app...) that uses the Microsoft OLE DB Provider for Jet. If you migrate […]

This article will guide you to quickly copy values without formulas in Excel. The example may be easier to understand if you […]

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