I'm using VLOOKUP in VBA to populate a cell in Excel. Currently I have the following code:
Set rng = Sheets("Sheet1").Range("H3:I33")
Debug.Print .VLookup(constant, rng, 2, False)
I'm getting the correct value printed out in my VBA editor. How do I get this value into the Excel cell? Maybe I don't have to use 'With application' to accomplish this?