Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pasting a forumla w/o the paste/special/value
Record a new Macro:
Copy the cell containing the formula Paste Special (Value) End Recording. You can either leave it in the Macro folder or create a button and assign the macro to it. - NewGuy "jc3000" wrote: Hi, Is there a function or a way to copy/paste/value a formula once the formula has calculated a number? I don't want to have to manually copy/paste/value. (I'm scraping info from the web, and i just want to grab the values and paste it in a cell.) Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
special forumla | Excel Discussion (Misc queries) | |||
In Excel: add a Paste-Special Option to paste IN REVERSE ORDER. | Excel Worksheet Functions | |||
How flip a selection before pasting - Paste special | Excel Discussion (Misc queries) | |||
Paste and Paste Special command are not enabled in Excel | Excel Worksheet Functions |