vba to find the last non blank cell in a range and then copy
Posted on 2014-03-18
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 _
Is only selecting 3 rows and
Is selecting to the end of the worksheet.