Copy, Paste in a specific format
 

I've tried a number of macros and cannot seem to get this formula down. I
would like to place my cursor on a specific row and copy Columns 3, 5 and 7
into an address format that I can then copy and paste to another program.
That address cell can be placed anywhere and isn't necessary to keep but
getting that formula down has been a headache when it seems it should be so
easy.

I'm not looking to do a Loop Macro, but one that is relative to the cursor
placement providing that Columns 3, 5 & 7 all have data when the macro is
initiated.

Any suggestions?