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.