Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL MACRO
I need to know how to create a macro to increase the value of any given
individual cell by a certain percentage. I want to assign a control button to the macro as well. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL MACRO
In a standard code module (the same place as the code for a recorded macro
lands) place the following procedure. Public Sub ChangePercent() Dim rng As Range On Error Resume Next For Each rng In Selection rng.Value = rng.Value * 0.5 Next rng End Sub Add a command button from the forms toolbar to a worksheet and when prompted select this macro. It changes the values of all selected cells by 50%. -- HTH... Jim Thomlinson "BobF" wrote: I need to know how to create a macro to increase the value of any given individual cell by a certain percentage. I want to assign a control button to the macro as well. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |