Copying only cells with data in them

  • Thread starter Thread starter JK192503
  • Start date Start date
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!
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
copy rows in range if data in first cell 7
Copy Data from Sheet 1 to Empty Cell in Sheet 2 2
Copy value from changing cells without VBA 1
Variable Range Copy... 13
help with weird select-cell-copy-from-previous-worksheet function 1
Copy & Paste Only Those That Don't Exist 2
Copy rows with values in sheet 1 to next empty row in sheet2 2

Back
Top