I'm attempting to set a variable in VBA to the value returned when executing this array formula during a loop:
I've attempted to use the Evaluate method but can't seem to get...
in one sheet I have data like:
A1: Audi B1:A3
A2: BMW B2:Z300
A3: Ford B3:Fiesta
A4: Audi B4: A4
A5: Ford B5: Mondeo
in second sheet I have unique value:
Now I want to insert into second sheet in B1, B2... all value from sheet1 for Audi, Ford etc...:
B1: A3, A4...
I am trying to use the following code, but I keep getting the "Subscript Out of Range" error.
I'm sure it has to do with the my variable:
The code basically looks in each worksheet to see if there is data in it and if there is, I want to print that to PDF.
Dim ArrSheets As String...
Can someone help me determine the right code to store an array formula into a cell? For example, I can use the below to store a non-array formula but how do I modify it to store an array formula? (i.e. with the curly braces on the outside) Generally, we would have to hold down...