If it is formatted in the cell that way, then try

Set wdRng = wdApp.ActiveDocument.Bookmarks(myArray(7)).Range
wdRng.InsertBefore (Sheet1.Range("Tax").Text)

if not

Set wdRng = wdApp.ActiveDocument.Bookmarks(myArray(7)).Range
wdRng.InsertBefore (Format(Sheet1.Range("Tax"),"$#,##0"))


assuming Range Tax contains a number such as you describe.

--
Regards,
Tom Ogilvy


"peter.thompson"
<peter.thompson.21gqim_1136970605.2089@excelforu m-nospam.com wrote in
message news:peter.thompson.21gqim_1136970605.2089@excelfo rum-nospam.com...

Tim,

Thanks a bunch for that, now works fine!...now my attention is on
solving the formatting issue

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile:
http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=500051