| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(FAO "Mike H") Multiplying cells using vb codes??????????
Mike H,
You gave me the following code sum cells. UserForm1.TextBox321.Text = WorksheetFunction.Sum(Range("BR4:BR14")) Which works great................Thanks. I have one more question, how do I Multiply to cells together using the same code? -- Tdp |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
(FAO "Mike H") Multiplying cells using vb codes??????????
On Sun, 14 Dec 2008 07:55:00 -0800, Tdp
wrote: Mike H, You gave me the following code sum cells. UserForm1.TextBox321.Text = WorksheetFunction.Sum(Range("BR4:BR14")) Which works great................Thanks. I have one more question, how do I Multiply to cells together using the same code? Replace the Sum part of your code with Product, like Product(Range("A10","C13")) if cells A10 and C13 are the two cells you want to multiply. Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
(FAO "Mike H") Multiplying cells using vb codes??????????
Sample code
Sub Test() For i = 1 To 10 Cells(i, 1) = Cells(i, 3) * 5 Next i End Sub This will multiply the cells in C1:C10 with 5 and put the result in A1:A10 "Lars-Ã…ke Aspelin" wrote: On Sun, 14 Dec 2008 07:55:00 -0800, Tdp wrote: Mike H, You gave me the following code sum cells. UserForm1.TextBox321.Text = WorksheetFunction.Sum(Range("BR4:BR14")) Which works great................Thanks. I have one more question, how do I Multiply to cells together using the same code? Replace the Sum part of your code with Product, like Product(Range("A10","C13")) if cells A10 and C13 are the two cells you want to multiply. Hope this helps / Lars-Ã…ke |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
(FAO "Mike H") Multiplying cells using vb codes??????????
Thank you both,
They both work. -- Tdp "Sheeloo" wrote: Sample code Sub Test() For i = 1 To 10 Cells(i, 1) = Cells(i, 3) * 5 Next i End Sub This will multiply the cells in C1:C10 with 5 and put the result in A1:A10 "Lars-Ã…ke Aspelin" wrote: On Sun, 14 Dec 2008 07:55:00 -0800, Tdp wrote: Mike H, You gave me the following code sum cells. UserForm1.TextBox321.Text = WorksheetFunction.Sum(Range("BR4:BR14")) Which works great................Thanks. I have one more question, how do I Multiply to cells together using the same code? Replace the Sum part of your code with Product, like Product(Range("A10","C13")) if cells A10 and C13 are the two cells you want to multiply. Hope this helps / Lars-Ã…ke |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I disable "cutting cells" and "drag and drop "in excel ? | Excel Worksheet Functions | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Check if cells contain the word "Thailand", return "TRUE" | Excel Worksheet Functions | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| multiplying by blank cells input by "IF" functions | Excel Discussion (Misc queries) | |||
Hybrid Mode
