I really really want to know how to propagate a macro from one area to another - if that makes sense...
A simply example: While recording a macro, if i select a line from col B to J, and then turn it bold, how can i write the cell refs so that this simple operation repeats to the next line each time i run the macro (eg by pressing my shortcut key).
Or, if my cursor has highlighted the cell in column A, with my macro i want to select and underline the rest of the row (to J) - but then i want to select another line and have the macro underline this new line and not automatically go back to the original line. Understand????
please help - its driving me mad
A simply example: While recording a macro, if i select a line from col B to J, and then turn it bold, how can i write the cell refs so that this simple operation repeats to the next line each time i run the macro (eg by pressing my shortcut key).
Or, if my cursor has highlighted the cell in column A, with my macro i want to select and underline the rest of the row (to J) - but then i want to select another line and have the macro underline this new line and not automatically go back to the original line. Understand????
please help - its driving me mad