R Rick Dec 12, 2003 #1 How do I use the "end" command in a macro? Or, can someone recommend a good book that will explain macros to me?
How do I use the "end" command in a macro? Or, can someone recommend a good book that will explain macros to me?
O Otto Moehrbach Dec 12, 2003 #2 Rick Much the same way you use the End key. Say the active cell is A10 and you want to do End - Up but do it in code. You would write it this way: ActiveCell.End(xlUp).Select or .Copy or whatever you want to do with that cell. HTH Otto
Rick Much the same way you use the End key. Say the active cell is A10 and you want to do End - Up but do it in code. You would write it this way: ActiveCell.End(xlUp).Select or .Copy or whatever you want to do with that cell. HTH Otto
