In writing a VB macro for an Excel workbook, I want the user to be able to
insert a row in the active sheet by clicking a (command) button, and then
have the macro continue to do some copying, etc. Because the active cell's
row is unknown, how do I get the macro to make column 1 of the active row
(cell A?) the active cell?. Certain other macro actions will be dependant on
this.
All help appreciated!