Try John Walkenbach's site for copying a noncontigous range of cells.

http://www.j-walk.com/ss/excel/tips/tip36.htm

Ron De Bruin's site offers solutions for emailing Excel data, ranges,
worksheets, etc.:

http://www.rondebruin.nl

Hope this helps.

furbiuzzu wrote:
Hi all,

i want to copy inside an email the text or values contained in
non-adiacent cells spread over a worksheet.

how can i solve this problem??

thanks in advance.

fulvio salvo.