IN THIS ARTICLE
Posts Categorized: VBA
How to calculate time in Excel – time difference, adding / subtracting times
This tutorial focuses on various ways to calculate times in Excel. You will find a few useful formulas to add and subtract times, calculate time difference, or elapsed time, and more.
In the last week’s article, we had a close …
Here’s a self-contained illustration of one way to “slice” a 2-D array
Sub ArraySlicing()
Dim arr(1 To 5, 1 To 5)
Dim slice
Dim x, y
Dim a As Application
'Populate a sample 2-D array with values...
For y = 1 To 5
For x = 1 To 5
arr(y, x) = 为了打开有中文名称的宏及Module,要Unselect this checkbox
VBA – How to auto fit row height of merged cells in Excel
How to auto fit row height of merged cells in Excel? (extendoffice.com)
Option Explicit
Public Sub AutoFitAll()
Call AutoFitMergedCells(Range("a1:b2"))
Call AutoFitMergedCells(Range("c4:d6"))
Call AutoFitMergedCells(Range("e1:e3"))
End Sub
Public Sub AutoFitMergedCells(oRange As Range)
Dim tHeight As Integer
Dim iPtr As Integer
Dim oldWidth INDIRECT formula to dynamically refer to another worksheet ->INDIRECT(“‘” & Sheet’s name & “‘!” & Cell to pull data from)
Excel INDIRECT function – basic uses and formula examples (ablebits.com)…
Benefit for learning VBA
Unlike macros, VBA enables you to do the following:
- Work with complex logic structures (case statements, loops, and so on)
- Take advantage of functions and actions not available in macros
- Loop through and perform actions on recordsets
- Perform transaction processing
ParamArray
The ParamArray keyword allows you to accept a dynamic number of arguments.
The word ParamArray is an abbreviation for parameter array.
Instead of using a large number of optional parameters it might be better to use a parameter array instead.…