copy row's value

Giganews Newsgroups
Subject: copy row's value
Posted by:  Nicawette (nicolasdestr…@yahoo.fr)
Date: 13 Jun 2006

Hi,

I'm a newbies in excel and I want to know if it is possible to
copy/paste in an another sheet only row's values and not formulas using
this :

..EntireRow.Copy Worksheets("Sheet1")

this is usefull but it copies the formulas not the value of the
formula.

Thank you for your help

Nic

Replies