Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot copy formulas
I use this line in my macro
Range("b2:z2").Select Range(doel).Select Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Somehow excel copies also the values. Whay am i doing wrong? Greetings Hans |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot copy formulas
I use this line in my macro
Range("b2:z2").Select Application.CutCopyMode = False Selection.Copy Range(doel).Select Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False Somehow excel copies also the values. Whay am i doing wrong? Greetings Hans |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
cannot copy formulas
'-------------------------------------
Range("b2:z2").Select Range(doel).Select '-------------------------------------- You immediately change the selection, so the first line is not needed. '- You say that values are pasted. 1. You will need to check your formulas are correct, because if the refer to the same cells then they will of course show the same values. 2. Or, perhaps, you have Calculation set to Manual when the cells woul not change until a re-calculation occurs. Hope this helps -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy formulas | Excel Discussion (Misc queries) | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
Copy Value not formulas | Excel Worksheet Functions | |||
Range COPY function - how to copy VALUES and not formulas | Excel Programming |