The following code gives me an "object variable or With block variable not set" error
[VBA]Private Function GetRow(RecID As Variant) As Long
GetRow = cLog.Columns(cPrimaryKeyColumn).Find(What:=RecID, LookIn:=xlValues)
End Function[/VBA]
cLog is a worksheet
cPrimaryKeyColumn is just as it sounds
RecID is the search parameter
the function is suppose to find and return the row that RecID is in.