Hi ,
There are many methods for identifying the last row & column.
You may want to check these links before trying out a particular method.
1)
http://www.mrexcel.com/td0058.html
2)
http://www.ozgrid.com/VBA/ExcelRanges.htm
For the code to unprotect the sheet & insert 10 rows, just a record a macro
for the same & use that code.
HTH,
--
Tausif Mohammed
"leimst" wrote:
I'm looking for a good way to identify the last row and column, in a list on
a protected sheet, and then add 10 rows by executing a macro assign to a
"button".
Thanks in advance for any help,
Brian