use event macro
worksheet_selectionchang
under this write your macro

"pcor" wrote in message
...
I think I need a macro ....
I would like to be able to place my cursor anywhere on the spreadsheet and
then click a macro that would concatonate all the data on the line
immediately above where the cursor is loctaed,
IE
If I place the cursor on line a14 I would want to concatonate all the
data
on line 13 from a13 to e13
Need help...and thanks
PCOR