Hi! I am new to VBA and I am looking for a book or website, which contains every "expressions" in VBA.
Every time I have a small exercise, and I try to figure out the solution, it's annoying that there are always new "expressions" in the soluton, which I have never seen before. So it's impossible to figure out things you haven't heart about until that moment.
For example "Insert multiple rows":
Sub InsertMultipleRows()
Dim i As Integer
Dim j As Integer
ActiveCell.EntireRow.Select
On Error GoTo Last
i = InputBox("Enter number of columns to insert", "Insert Columns")
For j = 1 To i
Selection.Insert Shift:=xlToDown, CopyOrigin:=xlFormatFromRightorAbove
Next j
Last:Exit Sub
End Sub"And it contains "On error go to last" or "xlFormatFromRightorAbove" expressions and so on, which I haven't seen before.
Or I could mention an easy "Font.Bold.=True" expression too...
So I need a website, or list, where every "expression" is listed and I can think about them, which to use or combine. Thank for your time and energy! Have a nice day!
Every time I have a small exercise, and I try to figure out the solution, it's annoying that there are always new "expressions" in the soluton, which I have never seen before. So it's impossible to figure out things you haven't heart about until that moment.
For example "Insert multiple rows":
Sub InsertMultipleRows()
Dim i As Integer
Dim j As Integer
ActiveCell.EntireRow.Select
On Error GoTo Last
i = InputBox("Enter number of columns to insert", "Insert Columns")
For j = 1 To i
Selection.Insert Shift:=xlToDown, CopyOrigin:=xlFormatFromRightorAbove
Next j
Last:Exit Sub
End Sub"And it contains "On error go to last" or "xlFormatFromRightorAbove" expressions and so on, which I haven't seen before.
Or I could mention an easy "Font.Bold.=True" expression too...
So I need a website, or list, where every "expression" is listed and I can think about them, which to use or combine. Thank for your time and energy! Have a nice day!