Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows with values - not formulas
Hi
First step is no problem: in Sheet1 col AI this formula is inserted with VB to add age groups =OM(OCH(Age=0;Age<7);"a. 0-6";OM(OCH(Age6;Age<16);"b. 7-15";OM(OCH(Age15;Age<26);"c. 16-25";OM(OCH(Age25);"d. 26-";"")))) Col is autofilled to last used row. In next step I loop thru these rows to find certain rows and copy them to Sheet2. Problem is that formula on each row is then copied. Instead I need it to be values only! Needs to work in Excel 2003 and 2007. Sheet1 can have 20 000 rows Any smart ideas how I should handle this? Thanks Ulf |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy rows with values - not formulas
It will be xlPasteValue. So, something like this...
Sheets("Sheet2").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "ulfb" wrote: Hi First step is no problem: in Sheet1 col AI this formula is inserted with VB to add age groups =OM(OCH(Age=0;Age<7);"a. 0-6";OM(OCH(Age6;Age<16);"b. 7-15";OM(OCH(Age15;Age<26);"c. 16-25";OM(OCH(Age25);"d. 26-";"")))) Col is autofilled to last used row. In next step I loop thru these rows to find certain rows and copy them to Sheet2. Problem is that formula on each row is then copied. Instead I need it to be values only! Needs to work in Excel 2003 and 2007. Sheet1 can have 20 000 rows Any smart ideas how I should handle this? Thanks Ulf |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy (Formulas and Formatting ONLY) no values to other rows | Excel Discussion (Misc queries) | |||
copy formulas without associated values | Excel Worksheet Functions | |||
Rows & Cols - copy formulas in Col A to # rows in Col B | Excel Programming | |||
Copy Values, not formulas | Excel Programming | |||
Range COPY function - how to copy VALUES and not formulas | Excel Programming |