excel macro - copy/paste without excess rows
Posted 07 December 2017 - 09:41 PM
i have another tab with a macro mining filtered fields.
i only want 6 columns in the end of the 30 original columns to paste over.
in doing so it pastes each column with running rows into millions when there should only be for example 10 rows of data per column.
any ideas how to set range with values indtead of creating a million rows of blanks space?
Posted 08 December 2017 - 02:08 PM
Real DJs use SL1200GAEs
Posted 11 December 2017 - 08:51 PM
If i understand you correctly you are moving the data from one worksheet to another using a VBA macro. And the VBA macro will copy the cells from one worksheet to another for selected column you want to move over, and you are copying and pasting blank rows into the other sheet?
If so you have two options.
One create a dynamic named range and reference those in your code.
Or two when looping through the cells in the range if the value of the cell is equal to an empty string simply break out of the loop.
Posted 12 December 2017 - 11:55 AM
Damn son, I need to up my excel game.
- broke likes this
1 user(s) are reading this topic
0 members, 1 guests, 0 anonymous users