EXCEL VBA TUTORIAL EXCEL DOWNLOAD HOW TO

'You can use Acctivate Method to activateР В РІР‚СњР вЂ™Р’В®xcel VBA Macros for Beginners- Novice Example 8: How To Get The Active Sheet Name And Workbook Name 'Example 7: How To Select And Activate Worksheet To activate one particular sheet we can use Activate method of a worksheet. This example will help you to select one particular worksheet. Range('A1:D11').Copy Destination:=Range('H1')Р В РІР‚СњР вЂ™Р’В®xcel VBA Macros for Beginners- Novice Example 7: How To Select And Activate Worksheet 'Example 6: How To Copy Data From One Range To Another Range This example will help you to copy the data from one particular range to another range in a worksheet using VBA. Range('C3').Value = LCase(Range('C3').Value)Р В РІР‚СњР вЂ™Р’В®xcel VBA Macros for Beginners- Novice Example 6: How To Copy Data From One Range To Another Range 'You can use LCase function to change the text into Upper Case 'You can use UCase function to change the text into Upper Case 'Example 5: How To Change The Text To Upper Case Or Lower Case If you wan tot change the text or string from upper case to lower case, we can use LCase function. This example will help you to change the text from lower case to upper case. Range('B1:B10').Font.ColorIndex = 3 ' 3=RedР В РІР‚СњР вЂ™Р’В®xcel VBA Macros for Beginners- Novice Example 5: How To Change The Text To Upper Case Or Lower Case 'Example 4: How To Change The Font Color And Font Size Of A Particular Range The following method will use the font ColorIndex property of a range to change the font color. We can differentiate or highlight the cell values by changing the text color of range in the worksheet. You may need to change the font color of range or cell sometimes. Range('B1:B5').Interior.ColorIndex = 5 ' 5=BlueР В РІР‚СњР вЂ™Р’В®xcel VBA Macros for Beginners- Novice Example 4: How To Change The Font Color And Font Size Of A Particular Range

'You can set the background color using Interior.ColorIndex Property 'Example 3: How To Change The Background Color Of A Particular Range We can use ColorIndex property of a Ranger Interior object to change the fill color of a range or cell. The following example will help you in formatting a cell or range by changing the background color of a range. 'You can also use Cell Object as shwon below B6:Р В РІР‚СњР вЂ™Р’В¬ells(6, 2) = 'Hello World! using Cell' 'Here 6 is Row number and 2 is Column numberР В РІР‚СњР вЂ™Р’В®xcel VBA Macros for Beginners- Novice Example 3: How To Change The Background Color Of A Particular Range 'Example 2: How To Enter Data into a Cell This example will show you how to write the data from VBA to Spread sheet range or cell. MsgBox Cells(5, 1) 'Here 5 is Row number and 1 is Column numberР В РІР‚СњР вЂ™Р’В®xcel VBA Macros for Beginners- Novice Example 2: How To Enter Data into a CellР В РІР‚СњР В РІР‚С›fter performing some calculations using VBA, we generally write the results into worksheet ranges. 'You can also use Cell Object to refer A5 as shwon below: 'It will display the A5 value in the message Box 'Example 1: How To Access The Excel Range And Show The Value Using Message Box This example will show you how to read the data from a worksheet range.

While automating most of the Excel Tasks, we need to read the data from Excel spread sheet range and perform some calculations. How To Print 1000 Values Р В Р вЂ Р В РІР‚С™Р Р†Р вЂљРЎС™ A Simple Example On For LoopР В РІР‚СњР вЂ™Р’В®xcel VBA Macros for Beginners- Novice Example 1: How To Access The Excel Range And Show The Value Using Message Box.How To Compare Two Values Р В Р вЂ Р В РІР‚С™Р Р†Р вЂљРЎС™ A Simple Example On If Condition.How To Set The Row Height And Column Width.How To Insert And Delete Rows And Columns.How To Hide And Unhide Rows And Columns.How To Create New Workbook, Add Data, Save And Close The Workbook.How To Add New Worksheet And Rename A Worksheet and Delete Worksheet.How To Get The Active Sheet Name And Workbook Name.How To Copy Data From One Range To Another Range.How To Change The Text To Upper Case Or Lower Case.

How To Change The Font Color And Font Size Of A Particular Range.How To Change The Background Color Of A Particular Range.How To Access The Excel Range And Show The Value Using Message Box.

Excel vba tutorial excel download