The Intersect method is used to Returns a Range object that represents the rectangular intersection of two or more ranges. If one or more ranges from a different worksheet are specified, an error is returned. Syntax: expression.Intersect (Arg1, Arg2, Arg3, Arg4, Arg5, Arg6, Arg7, Arg8, Arg9, Arg10, Arg11, Arg12, Arg13, Arg14, Arg15, Arg16, Arg17, Arg18, Arg19, Arg20, Arg21, Arg22, Arg23, Arg24, Arg25, Arg26, Arg27, Arg28, Arg29, Arg30) expression represents a variable that represents an Application object in excel. Parameters: Name Required/Optional Data […]
Excel formula to generate random strings.
December 21, 2024
Random texts are a great, they can be used as the filler texts where you want to show representational text. Or we can generate random text to use as password generator that is secure and hard to crack by notorious users using formulas in excel. You can use Excel formulas […]
Convert Html To Text In Excel
December 21, 2024
VBA code to convert html to plain text, this helps us to make the html code readable by stripping all the html tags from the html code and printing/rendering the output of the code. When we have a an Excel sheet with cells containing html. We can batch convert them […]
Adding A ToolTip To Any Cell In Excel
December 21, 2024
When we make a form for others to fill out it is helpful to have some tips to let them know what the cell represent so that they fill out the correct details in the cells. The tooltip or infotip or a hint is a common graphical user interface element. […]
VBA Message Box Set No as Default Button
December 21, 2024
How to Set No or Cancel as default Msgbox button? In Msgbox with YesNo or OkCancel buttons, the first button will be set as default button. i.e., once the message box appears if user hit Enter button, Yes or Ok will be activated. Sometimes, this is not desired. In case […]
Excel VBA List Files in Folder – Dir in Shell
December 21, 2024
List Files in Folder using Excel VBA To get list of files in a directory, just give the folder path as input to this function. It will read the file in the folder one by one. Then display the file names. In this sample code, we will get list of […]
Add Excel VBA Drop Down Data Validation List
December 21, 2024
How to add Data validation drop down list in Excel VBA? Two different methods to create drop down list are explained here – but all are related to validation list. Note: Combo-box control that also display list of values in dropdown is not explained in this page. Adding Drop Down […]
20% Discount Offer link for Fiverr – Hire Experts at affordable Prices
December 21, 2024
Fiverr – Microjobs Posting Platform If you are looking to hire quality expert to get your job done, Fiverr is right choice. Either you can post Job details with price & timeline, wait for experts to bid for it. Or you can directly filter available experts & pay for the […]
VBA Msgbox with Yes No Cancel Options
December 21, 2024
User Input Msgbox with Yes No Cancel Some time the VBA code has to get approval from user with Yes/No/Cancel optop. Here is the simple code snippet that get the Yes, No, Cancel options in a popup window. Example scenario for this would be like if there is any file […]
Convert Excel to Jpg Image – VBA Code
December 21, 2024
Export Excel Range to Image (jpg/png/gif) using Vba? This code ill convert the data in Excel workbook into a jpg image file as how it is displayed on screen. The image format can be jpg, png or gif. We have not tested if this supports other image formats as well, […]