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 […]
Convert Excel to Jpg Image – VBA Code
December 03, 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, […]
Excel Vba Sort Array – Quick Trick using built in function
December 03, 2024
VBA Array Sort – Using Excel Sort In this page, we have given a Excel vba code snippet that works well for sorting array of 1 dimension. You can also customize & extend this code to work for 2 dimension array as well. We will publish the code for 2D […]