using variable as an argument in .find in VBA

[J_T_Excel]

Hello,

I have a variable called ProdVerLibAddy. The contents of the variable is currently "$D$2869". I want to use this address as the "after" argument in the .find method but I keep getting a type mismatch error. Here is the section of code.

ProdVerLibAddy = ActiveCell.Address
ProdVerLibAddyRow = ActiveCell.Row
With Worksheets("RevHistoryMaster").Range("H" & ProdVerAddyRow & ":" & "H" & ProdVerLibAddyRow)
Set c = .Find("A", After:=ProdVerLibAddy, LookIn:=xlValues)
If Not c Is Nothing Then
firstAddress = c.Address

Can I do this? I'm assuming I need to declare the variable as something other than a string or something to that effect but I can't figure it out. Any help is greatly appreciated. Thanks.

 

[pgc01]

Hi

Try:

 ... After:=Range(ProdVerLibAddy), ...