Welcome to LearnExcelMacro.com

[...] (Data Manipulation Language) etc. based their way of functioning. Here to execute a Query in excel macro, Queries can be categorized in to two categories: 1. Queries which returns NO records like [...]

[...] using Excel inbuilt function, I will give a brief about the same at the end of this Article. Excel Macro to Protect your Sheet To protect an Excel WorkSheet, Worksheet.Protect Method is used. Using [...]

[...] Dear Friends, Many of you who are interested in excel Macro or if you have ever tried to read and understand a VBA code, you would have seen two ways of [...]

[...] to write 3-4 articles which will be all around Microsoft Power Point Presentation but using Excel Macro. So as part of this tutorial you will basically learn how to Open, Close, save, Copy a slide [...]

[...] Dear readers, Before we discuss the Range Object technically, let us see what is RANGE in excel? In a very simple manner if I define Range, I [...]

[...] a RANGE or WorkSheet or Application Objects while RANGE itself is an Object. Cells returns a Range Object. Cells can be used without any parameter passed or a single parameter passed in it. Since [...]

[...] it, user will not be asked for any password. DrawingObjects: (Optional) This is Boolean type input. Default value is TRUE. True allows to protect all shapes in the Sheet. Contents: (Optional) [...]

[...] pdf using VBA Sometimes you may need to change the orientation of the page before printing from Excel VBA. It could be used even while exporting your Sheet to PDF format. All you need to do is before [...]

[...] Dear Readers, LearnExcelMacro.com is going to conduct a FREE online session on “Basics of Excel VBA”. This session is going to be conducted on Google-Hangout hence to receive an invite for this [...]

[...] article we will discuss on reading values stored in a Name range in Excel Sheet using Excel VBA. Name ranging in excel sheet means giving a name to a Range to refer it by the name [...]

[...] article, I emphasized mainly on how to execute different kind of queries in database using Excel VBA. I covered one example How to display or spread a RecordSet in excel Sheet. But in this article [...]

[...] , I am writing this new article about How can you read values stored in a Name range in Excel Sheet in Excel Macro . For the readers who are unaware or need more information about the [...]

[...] in database using Excel VBA. I covered one example How to display or spread a RecordSet in excel Sheet. But in this article I am going to focus on different ways of reading RecordSet Object. How to [...]

[...] your Query to get Record Set as a result of the Query 3. Spread all the records in to your Excel Sheet named “Data” Statement used to spread all the records of a recordSet in Excel Sheet (Without [...]

[...] from the above example it looks like both are same because they are used to refer a cell in excel sheet, but CELLS and RANGE both are not at all same. Find the main differences below: CELLS is a [...]

[...] of sharing a small VBA code to help you writing a code to print the Workbook, Worksheet, Cell Range, Chart etc. .PrintOut () Method is used to print any Excel Object. Syntax of .PrintOut Method [...]

[...] steps to make your excel cell work as a masked password text box. Step 1: Set your Cell or Cell Range as Hidden but NOT Locked First of all you need to decide which range or cells you want to allow [...]

[...] in a tabular format. Now you know what is Range in Excel Workbook. To represent or access this cell range, the Object which is used in Excel VBA is called Range Object. Range Object is the most [...]

[...] , it had returned the Cell as Range(“D3″) while here in this example it has returned the cell Range(“B1″) because here the whole sheets is considered as a single Range Object and Cells is [...]

[...] by the above VBA statement (refer the below picture) Explanation: In the above code all the optional parameters are omitted. Hence using all the default values for other parameters, this function has [...]

[...] .Protect Method in Excel Macro. Syntax: Note: Like .PrintOut Method this method has all Optional parameters too. WorkSheet.Protect(Password, DrawingObjects, Contents, Scenarios, UserInterfaceOnly, [...]

[...] Instr() Function This is a VBA function and not a Worksheet function (Excel formula). This function returns the Position of First [...]