Cell Row Comparison

ganabathy

New Member
Joined
Feb 15, 2019
Messages
1
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
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Watch MrExcel Video

Forum statistics

Threads
1,109,000
Messages
5,526,186
Members
409,686
Latest member
Tori83

This Week's Hot Topics

Top