Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Adding rows based on no of rows specified from a given position | Excel Worksheet Functions | |||
adding some rows in the middle of adding some other rows | Excel Programming | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
Adding Rows offsets to working rows across two worksheets | Setting up and Configuration of Excel | |||
adding rows | Excel Discussion (Misc queries) |