macro creation
Posted by lambros on January 02, 2002 2:48 AM
i want to create a macro. I want by pressing the shortcut button of the macro to divide a cell value with a constant number, ie 5.
Posted by Paul Akkermans on January 02, 2002 3:52 AM
The macro:
Sub Div_by_5()
ActiveCell.Value = ActiveCell.Value / 5
end sub
