| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Set the values of set of ranges to zero then restore previousvalu
On Feb 13, 10:19*am, caroline
wrote: 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 Nope, you description is hard to follow, please elaborate. |
| Reply |
| 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) | |||
Linear Mode
