Question...

Are you wanting to concatenate all rows or just the ones that meet certain
criteria?


"Jessica" wrote in message
...
I need to be able to concatenate blank cells without it showing a zero for
the cells that were true from an if statement but blank, or be able to
record
a macro that prompts me for a cell reference or can find a range of
cells(A:AK) based on AL having certain text in it. Can anyone help??? I am
ready to scream.