VeryForgetful
Board Regular
- Joined
- Mar 1, 2015
- Messages
- 242
Hi,
I'm getting a runtime 424 object required error with the code below. I was originally getting a 1004 unable to get the worksheet property of the vlookup class.
Any idea what is wrong with this code?
Thanks
I'm getting a runtime 424 object required error with the code below. I was originally getting a 1004 unable to get the worksheet property of the vlookup class.
Code:
Private Sub Worksheet_Activate()
Range("M7").Value = Application.WorksheetFunction.VLookup(F7.Value,Sheets("Data").Range("$B$2:$V$65536"), 21, False)
Range("M7").Copy Range("M8:M" & Cells(Rows.Count, 4).End(xlUp).Row + 0)
End Sub
Any idea what is wrong with this code?
Thanks