Cell Row Comparison

[ganabathy]

Dear sir,

I capture the stock market data into excel using this code

Private Sub Worksheet_Calculate()
capturerow = 2


currow = Range("A65536").End(xlUp).Row.


Just i got the live data from the software.

My question : i want to compare the 2 rows.
Example : a4 and a5.

just i want the result, If a5<a4 = buy, or a5>a4 = sell.

How to add in the vb code.

I don't very well in VBA. Now only using the VBA code.

Please do the needful.

Thanks and regards,

GAnabathy