Category: VBA/Macro

VBA/Macro 2 comments

use of 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. यह […]

Read more
VBA/Macro Leave a comment

Use of UCASE Function In Excel VBA Macro

UCASE   We use UCASE function in excel macro. With use of Ucase function we convert a string into upper case. We have “computer” value in A1 cell, I want that “computer” word will be converted in upper case like “COMPUTER” and will be pasted in A5 cell. For this we have to use Range(“A5”).Value=UCase(Range(“A1”).VALUE)   UCASE Function का प्रयोग हम Excel Macro में करते है. UCASE का प्रयोग कर हम किसी string के letter को Upper case में convert […]

Read more
VBA/Macro Leave a comment

Use of LCASE Function In Excel VBA Macro

LCASE   We use LCASE function in excel macro. With use of lcase function we convert a string to lower case. We have COMPUTER value in A1 cell, I want that COMPUTER word will be converted in lower case like “computer” and will be pasted in A5 cell. For this we have to use Range(“A5”).Value=LCase(Range(“A1”).VALUE) LCASE Function का प्रयोग हमलोग Excel Macro में करते है. LCASE का प्रयोग कर हम किसी string के letter को Lower case में convert करते […]

Read more