Using

destRange.Value = SourceRange.Text

doesn't work in my case since my source workbooks columns with regular text
and numbers as well as numeric text.
Preformatting the appropriate columns of the destination workbook as you
suggest and using my original

destRange.Value = sourceRange.Value

statement does the trick.

Thanks, Michael.
--
Al C


"Michael" wrote: