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