Learn Excel VBA Macro

Work on worksheet tab in excel

To go to first or last sheet First और last sheet पर जाने के लिए. In excel 2010 or previous version we had the button to scroll to the first and last sheet. Excel 2010 या पिछले versions में हमारे पास first और last sheet पर जाने के लिए scroll button था। But from excel 2013 that buttons have been removed. लेकिन एक्सेल 2013 से उस बटन को हटा दिया गया […]

April 27, 2020 Some Other Excel Tips Leave a comment

Indirect Function In Excel -1

We use Indirect function in excel to converts a plain piece of text which looks like a cell address into a usable cell reference. एक्सेल में Indirect Function का प्रयोग कर हम Cell Address की तरह दिखने वाले Plain text को usable cell referent में convert करते हैं. The address can be either on the same worksheet or on a different worksheet. Address उसी sheet पर हो सकता है या फिर दूसरे sheet पर. Syntax INDIRECT(ref_text, [a1]) […]

March 22, 2020 Uncategorized Leave a comment

Concatenate Multiple values in one cell

We have to Concatenate multiple cells value in one cell. हमें कई सारे cells का value एक cell Concatenate में करना है. There is some value in cell A1 to A6, we have to concatenate these value A1 to A6 into cell C3 with space यहाँ cell A1 से C6 में कुछ value है,हमें इन सारे values को C3 में space के साथ Concatenate करना है. Type =A1:A6&” […]

April 14, 2019 EXCEL VBA TIPS One comment

Open Last Modified Excel File From A Folder Through Vba

Dear All, We can use below vba code to open last modified excel file from a folder. Sub Last_Modified_File() x = InputBox(“put Folder Path”) folder_name = x & “\” flname = Dir(folder_name & “*.xlsx”) Do While Len(flname) > 0 dttime = FileDateTime(folder_name & flname) If dttime > qq Then qq = dttime End If flname = Dir() Loop folder_name = x & “\” flname = Dir(folder_name & “*.xlsx”) Do While Len(flname) > 0 dttime = FileDateTime(folder_name & flname) […]

December 25, 2018 LOOKUP & Reference, Uncategorized 3 comments

Match With Index In Excel

Use of Match Function With Index Match Function के साथ Index फंक्शन का प्रयोग The INDEX MATCH formula is the combination of two functions in Excel: INDEX and MATCH. INDEX MATCH formula Excel में Index और Match दो Functions का संयोजन है। =INDEX() returns the value of a cell in a table based on the column and row number. Column और Row की संख्या के आधार पर तालिका में cell का Value लौटाता है। =MATCH() returns the […]

November 20, 2018 VBA/Macro 2 comments

MKDIR Function in Excel Vba

MKDIR In excel vba we use MKDIR vba function to create folder. MKDIR Function का उपयोग हम excel vba में folder बनाने के लिए करते है. I have to make a folder in D Drive which name will be computer. For this we have type code हमें D drive में एक फोल्डर बनाना है जिसका नाम COMPUTER होगा. इसके लिए हमें यह कोड लिखना होगा. Sub MakeFolder() MkDir “D:\COMPUTER” End Sub This Code will make folder in D Drive. यह […]