Here’s the deal. I learned Lotus 1-2-3 easily enough, almost two decades back. But the course text never really got into macros, nor did the prof. (I can’t complain. We were taught how to transfer data between it and DBase IV, a more career-helpful skill at that time - It was a combined summer course, BTW.) A few years later I wanted to learn macros when using the 'puter at a social club. There was an excellent Lotus book handy. After a very LONG time I managed to learn the elements that the simple technique of flicking the recorder on and off do not address.
Designate a set of cells (part of a column) as the macro-
Indicate a cell as the end of the program-
Insert an instruction for unconditional branching-
… conditional branching-
Go to a subroutine-
I seem to remember writing dewn notes on what I gradually learned as above, plus cell-enter and retrieving the contents of a cell. But I didn’t save my notes. :smack: I suspect that EXCEL is once again similar enough that they would have been helpful.
NOW I want to do the same thing with EXCEL. As you may have figured, there are some thing I do not pick up especially easily. Please tell me how to do each of the above, or the best equivalent. (For all I know EXCEL macros allows for-next loops, and who know what else. That would no doubt be better than putting an “IF… THEN BRANCH to…” statement at the end of a set of instructions.)
Once I get all this down I know I will be able to write any program I desire.
Thank you in advance.