#excel-vba tips

[thinkleaf]

Automating Excel Charts Creation Using Macros - Excel VBA Tips

Automating Excel Charts Creation Using Macros – Excel VBA Tips

There are different ways for creating charts using Excel-VBA. We are discussing one of the way here, which is using Shapes.AddChart method.

Steps involved in this process 1. Defining an Object variable for chart 2. Setting the Object variable to the Shapes.AddChart method 3. Assigning data source for the chart 4. Deciding what type of chart we need 5. Plotting by Rows or Columns 6. Adding…

View On WordPress

[thinkleaf]

LBound and UBound Functions in Excel VBA

LBound and UBound Functions in Excel VBA

LBound & UBound in excel-vba is used to find starting and ending index of an array. These statements will be very useful when you need to loop through each element of an array whose size is not known. Mostly these statements will be useful for dynamic arrays.

Check out the below program which illustrates how to use the LBound & UBound

‘Program illustrating how to use LBound & UBound in Excel-VBA O…

View On WordPress