Jagwarman
asked on
Select a range of cells from the active cell
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.C opy but if there is a blank row it stops at that row.
I use Range(Range("A2"), Cells.SpecialCells(xlCellT ypeLastCel l)).Select when I know the cell to start from but in this case I don't
Appreciate any assistance.
Thanks
Would appreciate help on selecting a range of cells.
I am saying:
Range("B:B").Find("*Date*"
Then I want to select all non blank cells from wherever the active cell is.
I have tried
ActiveCell.CurrentRegion.C
I use Range(Range("A2"), Cells.SpecialCells(xlCellT
Appreciate any assistance.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys
ASKER
Qlemo, thanks but yours only seems to copy the cell with the date
Range("B:B").Find("*Date*"