Forum Discussion

Alecs's avatar
Alecs
Brass Contributor
Nov 06, 2022
Solved

simple macro: jump to selected column

Hello guys, need your help creating a macro button: in row 1, I have this formula: =IF(E2=TODAY();"today";"not") in row 2, I have typed each day within a month.   I need a button that once clic...
Macros and VBA
  • OliverScheurich's avatar
    OliverScheurich
    Nov 06, 2022

    Alecs 

    Sub today()
Dim i As Long
i = Application.WorksheetFunction.Match("today", Rows(1), 0)
Cells(2, i).Select
End Sub

    You can try this code. 

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Nov 06, 2022

Alecs 

Sub today()
Dim i As Long
i = Application.WorksheetFunction.Match("today", Rows(1), 0)
Cells(2, i).Select
End Sub

You can try this code. 

  • Alecs's avatar
    Alecs
    Brass Contributor
    Nov 06, 2022
    It works perfect! thanks!

Resources