Excel VBA Training

03/09/2015

08/03/2015

INT function returns the integer portion of a number.

Syntax =INT(expression)

www.ExcelCareer.com

06/03/2015

Interview Question>>>>>>>>>>
What is the difference between
Option Explicit and Option Base??????
Answer will be posted tomorrow.....
www.ExcelCareer.com

05/03/2015

Exact formula or =?

04/03/2015

Trend Line using line chart

03/03/2015

Unhide Column Shortcut

27/02/2015

Loop through all sheets:

Sub ShowWorkSheets()
Dim mySheet As Worksheet

For Each mySheet In Worksheets
MsgBox mySheet.Name
Next mySheet

End Sub

25/02/2015

This will be very helpful for the beginners.......
Keep Sharing....
Join us for Excel VBA Training......
Excel VBA Training

25/02/2015

The For Each Loop

The For Each loop is similar to the For ... Next loop but, instead of running through a set of values for a variable, the For Each loop runs through every object within a set of objects. For example, the following code shows the For Each loop used to list every Worksheet in the current Excel Workbook:

Dim wSheet As Worksheet
For Each wSheet in Worksheets
MsgBox "Found Worksheet: " & wSheet.Name
Next wSheet

25/02/2015

Triple Loop
You can use a triple loop to loop through two-dimensional ranges on multiple Excel worksheets.

Dim c As Integer, i As Integer, j As Integer

For c = 1 To 3
For i = 1 To 6
For j = 1 To 2
Worksheets(c).Cells(i, j).Value = 100
Next j
Next i
Next c

25/02/2015

You can use a double loop to loop through a two-dimensional range of cells.

Dim i As Integer, j As Integer

For i = 1 To 6
For j = 1 To 2
Cells(i, j).Value = 100
Next j
Next i