Determining last active cell in a protected worksheet
I need to ascertain the last used cell (actually the last used row and the
last used column) in a protected worksheet.
I have tried specialcells(xlLastCell) but this fails when the sheet is
protected.
Any help appreciated
|