Excel: Correcting Debug '424 Error'

I created the following code below and attached it to a button allowing me to enter a number into Cell A3, click my button and it displays the needed information from another worksheet. Overall it works, but I continue to get a "Run-Time error'424'" msg. What am I missing? Sub ShowDispo() Dim Res As Variant Dim Hold As Range Set Hold = Range("A3") Set InitialRange = Sheets("Hold").Range("H:J") Res = Activate.Vlookup(Hold, InitialRange, 3, True).Value End Sub

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of February 01, 2018.

For more resources for Microsoft Excel