Related:
- Duplicate line and decrease Id number
- How to duplicate a page in google docs - Guide
- Itunes duplicate songs - Guide
- Does instagram decrease image quality - Guide
- Excel duplicate rows n times ✓ - Forum - Excel
- How to decrease upload speed in utorrent - Guide
1 reply
Umm, this is a simple for loop:
a = 1
b = ThisWorkbook.Worksheets(1).Range("C1").Value
decVal = ThisWorkbook.Worksheets(1).Range("B1").Value
For n = a To b
newval = decVal - n
MsgBox (n & " is the Count for " & ThisWorkbook.Worksheets(1).Range("A1").Value & "s value of " & newval)
Next
This is the best start you could ever have for your homework. I hope this helped. I WILL NOT MODIFY IT based on your findings that it doesn't do exactly what you want. It does what you asked!
Have FUN!
a = 1
b = ThisWorkbook.Worksheets(1).Range("C1").Value
decVal = ThisWorkbook.Worksheets(1).Range("B1").Value
For n = a To b
newval = decVal - n
MsgBox (n & " is the Count for " & ThisWorkbook.Worksheets(1).Range("A1").Value & "s value of " & newval)
Next
This is the best start you could ever have for your homework. I hope this helped. I WILL NOT MODIFY IT based on your findings that it doesn't do exactly what you want. It does what you asked!
Have FUN!