formula vs vba

[mattress58]

This formula works, but I cant get the VBA to work. What am I doing wrong?


=INDEX(Store!EM17:EY100000,MATCH("01 Total"&"Contracted",INDEX(Store!EP17:EP100000&Store!EN17:EN100000,0),0),MATCH("Moves Out",Store!EM17:EY17,0))

Please Login or Register  to view this content.

[romperstomper]

You can't concatenate ranges like that in VBA. It would be simpler to just populate the cell with the formula - you can always convert it to a static value afterwards.

[mattress58]

Thanks for the response. Is there anyway to do it with out populating the formula?

[romperstomper]

You could use Evaluate and pass your original formula string to it, but I don't really see any benefit.