After many tries of get the proper syntax, I finally figured it out. Below is the final results:

l_nrechosp = RECCOUNT() + 1
l_chosp='=CRITERIA!$A1:$H$'+ALLTRIM(STR(l_nrechosp))
oexcel.ActiveWorkbook.Names.Add("hosprng",l_chosp)

Thanks to all for the input.