View Single Post
 
Old 12-10-2010, 03:53 PM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi again,
You can also create this macro yourself !!

Do like this:

Put cursor in cell B6. Start recording a macro (tools / macro / record...). By clicking on a symbol on the little "macro recorder box" (the one with the stop sign) you shift to "relativ references" (which will be needed here).

Type "yes" (without enter), followed by "arrow right" two times. Now you should by in cell D6. Press CTRL + semicolon.

Stop the recording. Your macro is now ready!

A suggestion is that you assign the macro with a shortcut (for example CTRL + Y).

Now you can just place the cursor in column B (B8 for example) and press CTRL+Y and the job is done!

Kind regards
Bjorn
Reply With Quote