Copy and paste range that contains data & copy and paste, if cell contains data

**Butcher1** · 11-28-2020, 11:17 PM

Please Login or Register  to view this content.

So far this code does what I need it to. What I additionally need it to do is copy and paste Calculator Range X2:AB2 and all cells below that contain data. However, column AB contains formulas that may or may not display a result, Im not sure if this matters for VBA language. I also need it pasted with all borders around it.

In addition I need it to look at AD10, see if there is text in the cell and copy and paste it along with the cell to the left. In formula language it would look like

Formula:

Please Login or Register  to view this content.

. I need it to do more, but once I see what the code looks I should be able to copy it and change cell references.

Thank you kindly.

**vba_php** · 11-29-2020, 01:48 AM

you can't use the enum called xlUP to copy select cells. all that does is find stopping points. and those stopping points are blank ranges (cells). furthermore, you can't paste data from one range to another naturally without using the xlPasteType enum to spec what you want copied:

https://docs.microsoft.com/en-us/off...el.xlpastetype

per this:

https://docs.microsoft.com/en-us/off...e.pastespecial

the pros here might know formulas that can help with this, but all I see is range looping.