Sveučilište u Zagrebu  |  Filozofski fakultet  |  Služba za informatiku  |  Kutak za korisnike  |  Teme

Excel makro za selekciju susjedne ćelije


Option Explicit


Sub jump_next_and_perform()


' Macro1 Macro

' Macro recorded 21.05.2005 by Gjuro Kladarić '

' Keyboard Shortcut: Ctrl+Shift+A



' select a cell below one currently selected

ActiveCell.Offset(1, 0).Select


' here comes an action you want to repeat from cell to cell

' for example, remove a link from a text in a cell

' Selection.Hyperlinks.Delete


End Sub

komentare molim ovdje