Author: Vijay A. Verma
Excel Quiz 46
VBA – Optimize File Size by Clearing Unused Area
Sometimes, you find that your file size is very huge even though data contained in not much. The reason for this is that there are unused formatting beyond your data range. Either you can clear off your rows and columns beyond data range but if this is frequent, you can use a macro to do…
Article 48 – Split A Workbook into Multiple Workbooks on the basis of a Column
Sometimes, we need to prepare multiple workbooks on the basis of entries in a column. It is all the more useful in organizations where you need to send files to stakeholders. For example, in below sheet, you want to split the files on the basis of entries in column C. You may also like to…
Tips & Tricks 176 – Create a Desktop Shortcut for Onedrive Documents
Sometimes, you might need to create a desktop shortcut to Onedrive documents. Below is a method for Excel documents which can be used for any MS Office document. First, you would need to find the path of Excel.exe on your computer.
Excel Quiz 45
Tips & Tricks 175 – Color Code for Official Color of Excel
Everybody sees the dark green color of Excel. The color code for this color is
VBA – Delete All Blank Rows
This macro will delete all blank rows from a sheet.
Tips & Tricks 174 – VBA – OR Condition in FIND
FIND is a very powerful function in VBA but it doesn't support OR condition. Hence, if you want to find say two values "A" or "B", then you can code an array within FIND. To do OR in FIND, you will need to use following code (this is a sample code only, there can be…
Tips & Tricks 173 – Data Validation for Case Sensitivity
There are scenarios when you want to put a data validation which is case sensitive. Hence you want USA to be entered as USA not as usa or uSA or uSA so on. You just want all capitals. Similarly, sometimes you need only small letters say maverick. Hence, not Maverick, mavericK etc.