Help me make such a macro on onliofis

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

Hey @Uchenichek

We are glad to welcome you to our forum! :wave:
What issue are you facing?

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 :upside_down_face:
Getting started with macros

You will need methods such as:
GetRange
ForEach
GetValue
GetRow
SetValue

Check your private messages