View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Steve Grosz Steve Grosz is offline
external usenet poster
 
Posts: 3
Default 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