| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copy row's value
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy row's value
TRY
Worksheet("Sheet2").Range("A1")EntireRow.Copy Worksheets("Sheet1").Range("A1").PasteSpecial xlPasteValues I just add some reference to complete the syntax. this should get you started. "Nicawette" wrote in message oups.com... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
copy row's value
tx jon jon, it works fine now :-)
JON JON wrote: TRY Worksheet("Sheet2").Range("A1")EntireRow.Copy Worksheets("Sheet1").Range("A1").PasteSpecial xlPasteValues I just add some reference to complete the syntax. this should get you started. "Nicawette" wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy paste formula to skip rows | Excel Worksheet Functions | |||
| How do I NOT copy hidden rows to a new worksheet? | Excel Discussion (Misc queries) | |||
| Copy and paste only the rows with subtotals | Excel Discussion (Misc queries) | |||
| reminder notifications in a column | Excel Discussion (Misc queries) | |||
| copy exact values from RangeA to Range B which has extra rows | Excel Discussion (Misc queries) | |||
Linear Mode
