Hi Bob,
Yes, it is to happen only on 1 worksheet, although there are several cells from which I want to send the cursor, to a different relevant cell.
My experience so far is in recording macros, identifying commands in them and copy/pasting as necessary. I have never learned VB.
I gather from what you are saying that "Worksheet_Change" is a reserved macro name within Excel, or within VBA. I also gather, or I guess "hope" that it will enable entry of a different set of instructions for different cells, each to operate alone if a value is entered in the relevant cell.
I don't know how to store "in an Excel Object corresponding to the worksheet", so perhaps you could shine a light here?
Back Monday
Many thanks,
Keith
|