How to Make VBA to Wait for Few Seconds? Sometimes You have to make code execution to halt (vba wait time) for few minutes. This happens when VBA code has dependency on external applications like IE page load, Outlook mail download or Database query retrieval etc. So, the VBA coed […]
Excel VBA Rename File – Without opening the File – 2 Easy Ways
Get Excel VBA Rename file – Macro code to change file name. Input existing file name with itspath & new name. This VBA code will rename file to new name..
Merge Multiple Excel Files to One – Selected Sheets
November 27, 2024
How to Combine Sheets from Multiple Excel to One? This flexible Excel app in this page will merge Worksheets from multiple Excel files to one file. The User gets the option to select which files they need to be merged. Just follow these simple steps to use this app: Copy […]
How to Increase Your Google account Storage Limit?
November 27, 2024
Google Photos does not provide unlimited space for photo uploads by default. User has to choose the options explained below during upload or later as explained below. Google Storage Limits & How to extend it? Google provides storage space in its cloud with these two services. Google Drive + Photos […]
Clear Excel VBA Immediate Window – Macro Code
November 27, 2024
Clear Excel VBA Immediate Window Manually There is no explicit option to clear immediate window. Just select all content in Immediate window using control + A, then press delete button. This is the only option to clear the data in this window. Excel VBA Code to Clear Immediate Window As […]
Google Photos – Shared Album Link – URL Not working
November 27, 2024
Google Photos – Shared Album Link not working You created an album & sharing it with Your friend using the URL or by directly adding them from contacts. But, Your friend gets this error message when they open the url link. “The link has been deleted or the URL is […]
Vba Check if Sheet Exists – If not Create
VBA Code to Check if Sheet with Name exists? This Excel vba code will check if sheet with a specific name exists in the workbook. As per Microsoft specifications, You can add as many number of sheets depending on the limits of Your computer’s memory. So, this loop will check […]
Rearrange Excel Sheets in Custom or Alphabetic Order with VBA
Custom Order or Alphabetical Order This page has VBA code that can arrange worksheets in a Excel file in: Custom Order as per user preference Alphabetic Order of the Sheet Names Lets get the code. VBA Code – Arrange Sheets in Custom Order To make the below code work, You […]
Excel VBA Comment Multiple Lines – Easy Menu Option
November 27, 2024
In Excel VBA comment multiple lines of code using this toolbar option. This can comment a block of selected lines of code or uncomment them.
These Online Notepads eases Your Job a lot – Wanna know how?
November 27, 2024
How to Store Notepad & Sticky Notes Online? We use Windows Notepad App or Sticky notes app so much extensively. It is easy to store easy reference text data in these apps. As time passes, these notes gets added a lot & we struggle to manage them properly. It is […]