This is a great forum and I learned a lot by searching past threads, but I'm stuck on a macro that should be simple. I want to compare the value of the selected cell with the value of the cell immediately to the left. If the selected cell is less than the cell to the left, I want to automatically run another maco as a subroutine. Otherwise, do nothing. Thanks for the help
Last edited by jbar; 06-23-2011 at 11:02 AM. Reason: Title change requested by moderator
As I look at what I posted, I realize that I didn't state it correctly. Obviously there is little value of comparing only two cells. It is really the B column comparing to the adjacent cell in the A column. Range is about 52,000
In excel, right click on the sheet tab where you want to do this and click 'view code'
Then in the drop down boxes at the top of the screen, select 'Worksheet' & 'SelectionChange'
You'll see this appear:
In here goes your macro. What you'll be doing is running this macro whenever a user clicks into a cell in a range of cells you specify.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by swoop99; 06-23-2011 at 10:27 AM.
Further:
If you want to do this automatically for 52,000 rows then....
put this macro in a normal module and run with a button or something, rather than using the SelectionChange event.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks