Select a range of cells from the current/active cell
Would appreciate help on selecting a range of cells.
I am saying:
Range("B:B").Find("*Date*", , xlValues, xlWhole, , , False).Select
Then I want to select all non blank cells from wherever the active cell is.
I have tried
ActiveCell.CurrentRegion.Copy but if there is a blank row it stops at that row.
I use Range(Range("A2"), Cells.SpecialCells(xlCellTypeLastCell)).Select when I know the cell to start from but in this case I don't
Appreciate any assistance.