Copying only cells with data in them

J

JK192503

I am trying to figure out a way to write a code that will select and copy
only those cells within a selected range that have data in them, and to
suppress those that are empty.

The information will eventually be "paste-special-ed" into a word document,
such that automatic updating is possible.

I'd appreciate any ideas anyone might have.

Thanks!
 
R

Rick Rothstein \(MVP - VB\)

You might need to clarify your request a little. This selection... is a
column or a row only? If not (that is, if it is rectangular in shape and
more than one row high and more than one column wide), how is the copy to
take place if you want to eliminate empty CELLS only (that is, how is data
"collapsed" to fill in the blanks)? Or did you mean "rows" when you said
"cells"?

Rick
 
Top