Skip to main content
How to Convert String to Array Using Formula in Excel
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 […]
How to avoid using Select in Excel VBA
I know that using .Select in Excel VBA is a bad habit, but I don't know how to avoid using it. Why […]
How to URL Encode a String in Excel VBA?
Is there a built-in way to URL encode strings in Excel VBA, or do I need to manually code this functionality? Before […]
How to Quickly Get idMSO in Excel?
The idMSO is used to uniquely identify a built-in control, tab, command, etc. Use this to interact with built-in objects. The idMso […]
How to Open a Web Page Using VBA
Use API method to open url with default browser Private Declare PtrSafe Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, […]
How to reset the VBE windows to their default positions
If you have some troubles with macro and projects explorer windows settings, after some bad manipulations. How to reset the VBE windows […]
The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine
For example, you have a 32-bit application (VBA, web app...) that uses the Microsoft OLE DB Provider for Jet. If you migrate […]
How to Quickly Copy Values Without Formulas in Excel?
This article will guide you to quickly copy values without formulas in Excel. The example may be easier to understand if you […]
limit Scroll Area on an Excel Worksheet
Sometimes, if you want to limit scroll area of an Excel worksheet, it means that the cells outside the scroll area cannot […]
Microsoft Query Error: "This data source contains no visible tables."
When you import data by using the Microsoft Query Wizard and choose Excel Files as data source, you may receive the following […]