array2

I would like to convert nominal data values into logarithmic values to understand rates of change. The data is in the form of an array and I would like to observe the log values given the first nominal value in the series compared to the current value. What formula can I use to do this if I...

In VBA I'm trying to generate an array (Array2) that takes values from another array (Array1) that meet a certain condition like the following code: Dim j As Long j = 0 For i = 0 To UBound(Array1) If Left(Array1(i), 4) = cnstVal Then ReDim Array2(j + 1) Array2(j) = Array1(i)...

The snippet of code below is giving me fits. I have a couple of input boxes putting in the variable name and the Stub1 is the path and the name of the file. It is throwing an error when I point to the network. "Run-time error '1004': Method 'OpenText' of Object 'Workbooks' failed. I cannot...

hello I need some help with a vba code that will copy various charts from 1 excel worksheet into 1 powerpoint slide. I know this is possible, but for some reason I cannot make heads or tails with various codes I've found online. This is my situation. I have an excel workbook with 16...

I have the following 2 arrays from A2:F7 (defined as Array1) and H2:M7 (defined as Array2) <tbody> Array1 Array2 6 7 8 9 10 60 70 80 90 100 1 A B C D E 10 1 2 3 4 5 2 F G H I J 20 6 7 8 9 10 3 K L M N O 30 11 12 13 14 15 4 P Q R S T 40 16 17 18 19 20 5 U V W X Y...