| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set the values of set of ranges to zero then restore previous valu
Hello,
Dim i As Long For i = 0 To 49 Set Rg = Range(Range("Country1").Offset(i * 75 + 20, 6), Range("Country1").Offset(i * 75 + 23, 23)) Next I would like to set the value of Rg to Zero, copy and paste the result of the calculation, then restore the previous values of Rg. Any idea? Thanks -- caroline |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I restore previous content before a save? | Excel Discussion (Misc queries) | |||
| restore previous version of file--HELP | Excel Discussion (Misc queries) | |||
| Restore Previous Version | Excel Discussion (Misc queries) | |||
| How can I restore a previous version of an excel document? | Excel Discussion (Misc queries) | |||
| how do I restore a document to a previous state? | Excel Discussion (Misc queries) | |||
Threaded Mode
