select multiple ranges in column and do x

[amartino44]

Hello. How do I select all used cells in a column with vba (no blanks). Thanks.

 

[jardenp]

I would filter out blanks then select the range (presumably the whole column). If you copy and paste from that, it only copies the visible cells, so there will be no blanks.