Hi Roger
thankyou for that just right
--
BD3


"Roger Govier" wrote:

Hi

Try
=[Book1.xls]Sheet1!D6&" "&[Book1.xls]Sheet1!F6
Regards

Roger Govier


bigdaddy3 wrote:
i have cell D6 and cell F6 to select in 1 workbook and then when another
workbook is opened by a macro i want to paste D6 and F6 into 1 cell together
G5 ie name fred and bloggs becomes fred bloggs.Both workbooks would be open.