Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all can any one help me with the following
Sub.... A1=Array(10) A2=Array(10) .................. Dim X3 Date Dim X4 Date Dim X5 Long A1(9) = Range("B8:L8") A2(9) = Range ("B9:L9") X5=(X3-X4)*1440 ............ I need to be able to take the difference of arrays (A1-A2) divide with X5 and put into a range of cells.. I do not know how to multiply Arrays for example Range("N9:W9")=(A1-A2)/X5 does not work..... does anyone have a sample of how to multiply an array with a constant? Thank you John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiplication of two array in a particular way | Excel Worksheet Functions | |||
Addition & multiplication formula | Excel Discussion (Misc queries) | |||
Multiplication | Excel Worksheet Functions | |||
multiplication | Excel Worksheet Functions | |||
Charts multiplication | Charts and Charting in Excel |