CompeteWithPete Posted December 7, 2017 Share Posted December 7, 2017 so i have one tab with data with all my data. 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? Quote Link to comment Share on other sites More sharing options...
Deft Posted December 8, 2017 Share Posted December 8, 2017 You should be able to just copy visible rows, if I understand roughly what you're trying to do. If you have an example workbook or some code I can look at it, though might not be until later on in the weekend as I'm commuting across the country at the moment. Quote Link to comment Share on other sites More sharing options...
Tbtf Posted December 11, 2017 Share Posted December 11, 2017 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. Quote Link to comment Share on other sites More sharing options...
Jam Burglar Posted December 12, 2017 Share Posted December 12, 2017 Damn son, I need to up my excel game. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.