Jagwarman
asked on
vba to find the last non blank cell in a range and then copy
Can an expert provide me with VBA code that will find the last blank cell [starting from the bottom of the sheet] and then copy the range.
i.e. the range is always A:K but the number of rows will vary.
I have tried a couple of ways of doing this but neither work for me.
Range(ActiveCell, Range(ActiveCell.Address). End _
(xlToRight).End(xlDown)).S elect
Is only selecting 3 rows and
Range(Range("A1"), Cells.SpecialCells(xlCellT ypeLastCel l)).Select
Is selecting to the end of the worksheet.
Thanks
i.e. the range is always A:K but the number of rows will vary.
I have tried a couple of ways of doing this but neither work for me.
Range(ActiveCell, Range(ActiveCell.Address).
(xlToRight).End(xlDown)).S
Is only selecting 3 rows and
Range(Range("A1"), Cells.SpecialCells(xlCellT
Is selecting to the end of the worksheet.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER