I have a problem about using find method in Excel VBA.
Here is my program:-
____________________________________________________________________________
Private Sub CommandButton2_Click()
Dim MyProduct As Range
Product = Range("F8").Value
Set MyProduct = ThisWorkbook.Sheets("Sheet2").Columns("E").Find(what:=Client, LookAt:=xlWhole)
ActiveSheet.Cells(8, 8).Value = MyProduct.Columns("G").Value
End Sub
____________________________________________________________________________
> how can I pull data in Columns(G) to Cells(8,8)
>the program I wrote ' ActiveSheet.Cells(8, 8).Value = MyClient.Columns("G").Value ' , give me error... Run-time error '91' Object variable or With block variable not set
>What does it mean?
> Please someone help me to solve this problem....