Excel 2007 : Copy cells with non blank values.

[enhydra]

Is there a way to copy cells in a row with only non blank values?

thx
E

[JBeaucaire]

1) Highlight the row of values
2) Press F5, click on Special

3) Select Constants if the row is full of flat values
Select Formulas if the row is full of formulas

...and leave all the subcategories checked

4) Click OK
5) Press CTRL-C to copy
6) Click on your target and press ENTER

[enhydra]

Cool, thanks JB. I learn something new everyday. Sometimes I feel like a chicken, everyday is the first day of my life.

thx
E