No Selection of Locked Cells on Protected Sheet
Hello!
I have a button on a sheet to add new rows using David McRitchie's InsertRowsAndFillFormulas code.
I want to restrict the range that gets used so I came up with this:
If the cursor is in A12:B40, the code works fine. However, if the cursor is in column C (for example), and the button is pushed, I get Run-time error 91, Object Variable or With Block Variable not set.
Please Login or Register to view this content.
Anyone see how to fix this code?
Lost
Last edited by leaning; 06-16-2011 at 09:28 AM. Reason: Solved!
Re: No Selection of Locked Cells on Protected Sheet
All,
This was taken care of by Domski's code in this thread:
http://www.excelforum.com/excel-prog...run-macro.htmlPlease Login or Register to view this content.
Thanks!
Lost
Thread Summary
All,
This thread solution is summarized by the following thread:
http://www.excelforum.com/excel-prog...ot-blanks.html
At the bottom of that thread, you will find two workbooks: one which adds rows at the bottom of a sheet, and another which adds rows in a middle section of a sheet.
99.9% of the tough stuff was by virtue of the Excel geniuses in this forum. Thanks all for helping complete a project which will make work easier for many, many people!
Respectfully,
Lost
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks