| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiply cells in range by corresponding factor
Hi, try something like this in a standard module:
Sub myCalc() Dim myCell As Range Dim C& For Each myCell In Selection If Application.WorksheetFunction.IsNumber(myCell.Valu e) Then C = myCell.Column myCell.Value = Cells(2, C) * myCell.Value End If Next End Sub HTH--Lonnie M. |
| Reply |
| 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 | |||
Hybrid Mode
