Hi all,
I hope you're doing well! Quick question – I think I remember it not being possible, but perhaps someone can prove me wrong.
I use the following to set the usedrange of my worksheet as an array in memory:
So saying
would give me the value in Sheet1.Range(“A1”)
But what if I want to do an Application.Vlookup or Application.Match on the array?
Using it as below gives me an Error 2042.
Is it just not possible and should I loop or is there some way to apply vlookup/match (or find, for that matter) on the 'sht' ?
Thanks,
Jasper
Bookmarks