Insert Array, designate EVEN or ODD

[Jose Gregorio]

I have two questions. I think the first is easy, so the second is the main question.

1. Using VBA, how to I designate that an equation is supposed to be an array?
2. I have four values, "high A", "low A", "high A", "low B".

The script is meant to read reference cel D5, which can either be 1 or 2.

If it's 1, it dumps the values of high A and low A into cels O4, P4.

If it's 2, it dumps the values of high B, low B into cels O4, P4.

The code I have:

Please Login or Register  to view this content.

Which doesn't work, and returns errors. I code this code looking online for how to solve the problem.

[MarvinP]

Hi Jose,

1. In VBA an array formula is entered with "FormulaArray" - see https://colinlegg.wordpress.com/2012...aarray-in-vba/

2. If D5 is either 1 or 2 then why not use those two values in your If statement?
If Range("D5").value = 1 then ... or
If Range("D5").Value = 2 then ...

[Trebor76]

In regards to point 2 you could use this:

Please Login or Register  to view this content.

Regards,

Robert