help me make such a macro on onliofis
Sub Кнопка1_Щелчок()
Dim mycel As Range
For Each mycel In Columns("D:D").SpecialCells(xlCellTypeConstants, 23)
If mycel = [Сегодня] Then mycel.Offset(0, 1) = [Данной_значение]
Next
End Sub
help me make such a macro on onliofis
Sub Кнопка1_Щелчок()
Dim mycel As Range
For Each mycel In Columns("D:D").SpecialCells(xlCellTypeConstants, 23)
If mycel = [Сегодня] Then mycel.Offset(0, 1) = [Данной_значение]
Next
End Sub
I need to convert this macro to js
Hi @Uchenichek
Unfortunately, we do not have automatic conversion of the visual basic > JavaScript macro.
It is necessary to do everything manually.
Usually, users write about problems or questions about available methods
Getting started with macros
You will need methods such as:
GetRange
ForEach
GetValue
GetRow
SetValue
Check your private messages