Hi All, I have some code that I'm using to populate a userform, which is:
cboRecall displays a list of value, and when selected will populate the userform with the values associated with the filtered item. I would then like to delete the row from which the data was extracted. The message box correctly shows from which row the data was filtered, but I try to delete it with the code
I get an "invalid qualifier" error.
If I change the code to
I get an "The object doesn't support this property" error.
...any suggestions?
Code:
Dim SearchRange As Range
Dim TargetRow As Range
Set SearchRange = Range("I3", Range("A65536").End(xlUp))
Set TargetRow = SearchRange.Find(Me.cboRecall.Value, LookIn:=xlValues, lookat:=xlWhole)
UserForm1.Show
'MsgBox TargetRow.Row
'additional code here....
Code:
TargetRow.Row.Delete
If I change the code to
Code:
Rows.TargetRow.Delete
...any suggestions?