Runtime Error 91 : Object Variable Or With Block Variable Not Set

[MCE2014]

Hi Im getting "Runtime Error 91 : Object Variable Or With Block Variable Not Set" from the following line of code.

Im relatively new to programming/VBA and i need help to find out what im doing wrong here:

r = Application.VLookup(Plant_No, Range("F2:F63"), i, False)

 

[JoeMo]

Hi Im getting "Runtime Error 91 : Object Variable Or With Block Variable Not Set" from the following line of code.

Im relatively new to programming/VBA and i need help to find out what im doing wrong here:

r = Application.VLookup(Plant_No, Range("F2:F63"), i, False)

Can you post enough of your code to allow us to see how the variables in bold red are dimensioned and initialized? Also, seems a bit strange to have a single column be the lookup range - is there a typo there?

 

[Wild_Vivek]

Plant_No is a variable and it is not set on ur code

just do Dim Plant_no as Integer