I gave you an example with cells.value?
what what the problem with it?

--
Regards,
Tom Ogilvy

"Craig" wrote in message
...
Hi Duane,
No, I haven't. Can you give me an example using the
Cells.Value concept (I don't quite understand the syntax
you've suggested), which is how I would be using it?

Thank you!
Craig


-----Original Message-----
have you tried left(ref,len(ref)-2)?


---
Message posted from http://www.ExcelForum.com/

.