| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
in VBA script, make cell values = formula value, not formula
Here is a snippet of my code:
Range("Z2:Z100).FormulaR1C1 = "=IF(ISBLANK(RC1),"""",CONCATENATE(VLOOKUP(msr!R2C 2,tbl.markets,2,0),(TEXT(msr!R4C2,""mmddyy"")),""-"",(TEXT(ROW(RC[-25])-1,""000""))))" Columns("Z:Z").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=True, Transpose:=False |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
in VBA script, make cell values = formula value, not formula
Part of my question disappeared!
So question is, instead of selecting then copying and pasting values. I want the values to get dumped straight in. Like killing the formula after I'm done with it only not by cutting and pasting values. Make sense? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
in VBA script, make cell values = formula value, not formula
Nevermind. I found the answer on Ron's Excel Tips. So easy, yet so elusive.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i make a formula to multiply two values? | Excel Worksheet Functions | |||
| How do I make a formula automatically detect changes in values | Excel Worksheet Functions | |||
| How to make a formula with < or> in a cell | Excel Discussion (Misc queries) | |||
| Help with formula to make cell blank | Excel Worksheet Functions | |||
| how to make a chart from formula values? VBA | Excel Programming | |||
Linear Mode
