| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Not resetting all cells
The following code works for the first ActiveSheet.ScrollBar1.Value command
works, but the ActiveSheet.ScrollBar2-9 commands do not. The last 4 commands (ActiveSheet.Range("D10) through "D16" also work. Appreciate any help. Thanks. ActiveSheet.ScrollBar1.Value = ActiveSheet.Range("U31") ActiveSheet.ScrollBar2.Value = ActiveSheet.Range("U32") ActiveSheet.ScrollBar3.Value = ActiveSheet.Range("U33") ActiveSheet.ScrollBar4.Value = ActiveSheet.Range("U34") ActiveSheet.ScrollBar5.Value = ActiveSheet.Range("U35") ActiveSheet.ScrollBar6.Value = ActiveSheet.Range("U36") ActiveSheet.ScrollBar7.Value = ActiveSheet.Range("U37") ActiveSheet.ScrollBar8.Value = ActiveSheet.Range("U38") ActiveSheet.ScrollBar9.Value = ActiveSheet.Range("U39") ActiveSheet.Range("D10") = Range("C10") ActiveSheet.Range("D12") = Range("C12") ActiveSheet.Range("D14") = Range("C14") ActiveSheet.Range("D16") = Range("C16") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Resetting cells to zero value. | New Users to Excel | |||
| Resetting multiple cells containing drop-down lists | Excel Discussion (Misc queries) | |||
| Resetting cells | Excel Worksheet Functions | |||
| resetting controlsource cells | Excel Programming | |||
| Resetting cells | Excel Programming | |||
Threaded Mode
