Range Selection Help

[yoshi_5]

Hi,

I'd like to select visible cells in the active column, the column will change throughout the code running process, so the column is not always pre-identified and I'd only use the active column based on selecting that column through code.

The last visible row is however identified. So I'd like to start at row number 1 and select down to the last visible row (already identified). I want to include blanks. Simply just select from row 1 to last visible row in whatever column is currently active.

I'm looking to copy the range to another workbook. I can't just use visible cells in the entire column as then all blanks after the filtered range are included and paste as well into the second workbook adding many rows of blank data which are not needed.

It seems like it would be so easy, but my searches over the past 2 days have come up with no relevant solution.

As always, thanks to anyone in advance who can be of assistance.

[Norie]

Sorry I'm confused, first you seem to say you want to include blanks, then you say you don't.

[yoshi_5]

I want to include blanks that are before the end of the filtered range. After the filtered range, I don't want to copy/paste those blanks any longer.

I believe I have found a solution, which of course I find 5 minutes after posting this... ugh... that's how it goes.

Please Login or Register  to view this content.

Please advise if you don't think that's the best solution to what I'm looking for..

Thank you Norie...

[Norie]

That looks fine, though you might want to try something like this to make sure you copy from the first row.

Please Login or Register  to view this content.

[yoshi_5]

Edit: Answered my own question again.

Thanks for putting up with a newbie.