| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
a way to make this more compact ??
aWS.Range("B2").Value = (aWS.Range("H7") - aWS.Range("A2").Value) * 100
aWS.Range("B4").Value = (aWS.Range("H7") - aWS.Range("A4").Value) * 100 aWS.Range("B6").Value = (aWS.Range("H7") - aWS.Range("A6").Value) * 100 aWS.Range("B8").Value = (aWS.Range("H7") - aWS.Range("A8").Value) * 100 aWS.Range("B10").Value = (aWS.Range("H7") - aWS.Range("A10").Value) * 100 aWS.Range("B12").Value = (aWS.Range("H7") - aWS.Range("A12").Value) * 100 aWS.Range("B14").Value = (aWS.Range("H7") - aWS.Range("A14").Value) * 100 etc etc.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compact Access DB from Excel | Excel Programming | |||
| This formula needs to be more compact. | Excel Worksheet Functions | |||
| Compact Workbook | Excel Discussion (Misc queries) | |||
| Compact | Excel Programming | |||
| Compact Excel Spreadsheet | Excel Programming | |||
Threaded Mode
