Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically divid
How I can make the number been divided automatically in the cell without
adding the divided number or make a formula like =A1/12 . |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically divid
You need to make a worksheet Change macro that when you enter data in certain
cells it will automatically will do the division. Usually you only want this done in certain columns or certain rows and not the entire worksheet Sub worksheet_change(ByVal target As Range) If target.Column = 6 Then Application.EnableEvents = False target.Value = target.Value / 6 Application.EnableEvents = True End If End Sub w "Ali.Abughrabieh" wrote: How I can make the number been divided automatically in the cell without adding the divided number or make a formula like =A1/12 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically Run macro | Setting up and Configuration of Excel | |||
alphabetize - automatically | Excel Worksheet Functions | |||
St automatically changes to So | Excel Discussion (Misc queries) | |||
Macro to automatically run | Excel Discussion (Misc queries) | |||
Run macro automatically. | New Users to Excel |