| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to copy cells value and not formula
Hi there,
i found something like this to copy a cell in a worksheet to another worksheet: Cells(1, 1).Copy Destination:=Worksheets("Sheet2").Cells(1, 1) This works fine for me for all field expect formula. I wanna copy the Value of this field but it copies the formula. How can i do this? Thank you for your advice! Greetz kaiserlich |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need to copy a formula to a 100 cells | Excel Discussion (Misc queries) | |||
| copy cells using formula | Excel Worksheet Functions | |||
| Copy Cells Formula | Setting up and Configuration of Excel | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| Copy a formula to a range of cells via VB6 using .Range(Cells(row,col), Cells(row,col)).Formula= statement | Excel Programming | |||
Threaded Mode
