Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiply cells in range by corresponding factor
I'm a beginner at writing VBA macros and I need some help. What I want
to do is to provide the ability to select a range of cells in a spreadsheet then click on a command button that runs a macro that multiplies the content of each cell in the selected range by a corresponding factor identified in row 2 of each column. (Example) In row 2 the cells contain (A2)5,(B2)5 and (C2)10; Cells A4:C5 contain values (A4)1,(B4)2,(C4)3,(A5)2,(B5)3,(C5)1. I select range B4:C5. After running the macro the cells now contain (A4)1,(B4)10,(C4)30,(A5)2,(B5)15,(C5)10. If anyone could provide the code to perform this task I could use your help. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multiply range of cells by a fluctuating exchange rate | Excel Discussion (Misc queries) | |||
How to multiply all cells in array by factor | Excel Discussion (Misc queries) | |||
multiply all values in all cells by a factor | Excel Discussion (Misc queries) | |||
Would like one cell to both count and multiply a range of cells | Excel Worksheet Functions | |||
Multiply one cell by a factor and make that result round | Excel Worksheet Functions |