How to accomplish?
Hello Thomas [PBD],
Ok, that sort of does what I would like. I would like to check to see if
b & c are the same, b is higher than c, or c higher than b, and display an
image indicating if there has been a increase (b higher than c) decrease
(c higher than b) or no change.....
Thanks!
Public Sub Sub_1()
Dim x As Long
x = Excel.WorksheetFunction.CountA(Columns("A:A"))
For y = 2 To x
Range("A1").Cells(y, 5).Formula = "=IF(C" & y & "B" & y &
",TRUE,FALSE)"
Next
End Sub
|