Thank you again,
Regards,
Jeff
"Frank Kabel" wrote:
Hi
typo. Use:
ret_value=application.vlookup("Total",Range("G" & startpos & ":H1000"),2,0)
--
Regards
Frank Kabel
Frankfurt, Germany
"Jeff" schrieb im Newsbeitrag
...
Hi,
Thank you again that is I wanted.
But I'm getting a Run-tiem error 1004 on this line:
ret_value=application.vlookup("Total",Range("G" & startpos & "H1000"),2,0)
Thanks,
|