Select non-empty cell range with VBA

Originally Posted by HerryMarkowitz

Try following code..

Sub Macro1()
ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants, 23).Select
End Sub

Thank you, but i have found two issues:
- i cannot copy the cells via Copy and Paste.
- rows that do not have values on all columns are selected; the selection should look like in the attached picture: Attachment 282782