Determing last (used) row in a sheet
Try this:
No_Rows = Cells.Find(What:="*", _
After:=Range("A1"), _
LookAt:=xlPart, _
LookIn:=xlValues, _
SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, _
MatchCase:=False).Row
Regards,
Stefi
€žAxel€ť ezt Ă*rta:
Hi,
determing the last (used) row with
Set LastCell = ActiveSheet.Cells.SpecialCells(xlLastCell)
No_Rows = LastCell.Row
seems not to work, as soon I am also deleting some content of the sheet.
Does anybody know what the problem is (or what would be a better solution)?
Kind regards, AXEL
|