Loweh000's blog
Compare 2 cols and replace lowest value in one of them? Help!
Submitted by Loweh000 on 28 January, 2012 - 19:20I have a spreadsheet with Prices in one column and Lowest Prices in another column.
At the moment I have 100 instructions like this:
If Range("d4") < Range("i4") Then Range("i4") = Range("d4")
through to
If Range("d100") < Range("i100") Then Range("i100") = Range("d100")
I know there is a better way using If statements and looping through the cells.
Can I find the syntax or an example of how to do this - NO!
Is there anyone out there with the solution? Any help would be really appreciated.
H
»
- 1 comment
- 2851 reads

Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago