I wanna know if there's a way to do that

i have 20 cells in 2 rows

A B C D .... AA <-- columns
X X X ... <-- cells used as check box
Z Z Z ... Z <-- cells used as headers
1 3 4 5 ... N <-- cells with values

I want to run a macro to concatenate, each time i push a button, all
the cells in a range that they are checked

So if i check the cells A B & D i want
THIS to happen -- =concatenate("A3";"B3";"D3")

Thanks in advance
-----------------------------------------
Stathis
Patras , Greece


---
Message posted from http://www.ExcelForum.com/