Materi

Example 1: This procedure uses the OnTime Method to auto increment cell value at specific time intervals, and Stops the […]

Example 2: This procedure uses the OnTime Method to auto increment cell value at specific time intervals, and Stops the

Sub trigonometri() Dim lembar As Worksheet Set lembar = Worksheets(5) a = 4 * Application.WorksheetFunction.Atan2(1, 1) Range(“B1”).Formula = Tan(a *

Sub rumus() On Error Resume Next Dim lembar As Worksheet Dim gambar1 As Shape Dim gambar2 As Shape Dim gambar3

Sub coba() On Error Resume Next Dim lembar As Worksheet Set lembar = Worksheets(1) Range(“J6”) = Range(“J6”) + 1 lembar.Shapes(“batang”).Rotation