Adding Rows
 

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

Adding Rows
 

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

Adding Rows
 

With Activesheet

.Unprotect
LastRow = ,Cells(.Rows.Count, "A").End(xlUp).Row
With .Rows(LastRow + 1)

'do something
End With
.Protect
End With

--
__________________________________
HTH

Bob

"leimst" wrote in message
...
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