How do I figure out last activecell? I can't figure this out.
Posted by A beginner on January 07, 2002 11:34 PM
I'm trying to add code to the worksheet event section where, if the user enters a value in the range b2 to j18, it automatically deletes any other values in that row from column b to j, and leaves the previous cell as is. I don't know how to find any commands for finding the previous cell used once the user either hits enter or clicks to another cell, or if there's a command like worksheetcell_exit like textbox_exit for example??? Thanks