Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Thursday, September 4, 2014 1:43:08 AM UTC-5, wrote:
I have an excel workbook that continuously reads values from external application via DDE and stores then to a range of cells. Those values are continuously changing. When those values are "satisfactory", I need to save a frozen copy into target ranges without using VBA since, by policy, it is denied. I can use copy-paste values, but it is time consuming since I have to repeat many times. Is there a formula to put in target ranges that can read from the "source" range and can freeze the value on command? TIA, David http://www.rondebruin.nl/win/s9/win015.htm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Changing Cells depending on data entered in other cells | Excel Programming | |||
Copy changing group of cells from Sheet1 to Sheet2 | Excel Programming | |||
Adjustable Cells (Changing Cells) Limit - Solver | Excel Discussion (Misc queries) | |||
Copy formula into multiple cells without changing range | Excel Worksheet Functions | |||
Show cells with formulas without permanently changing the cells | Excel Programming |