Hi I get a runtime error 13 when highlighting and deleting multiple cells at once within the rage define by the following code:
The code is designed to hide/unhide the row below if something has been entered in the cell above. Rows 29 through 47 are hidden to the user when they first open the workbook. With the error, the rows do not hide automatically once the content has been deleted.
The code below performs the same thing as the above, however, I do not get the error with the code below and the rows hide automatically when the content has been deleted. Any ideas as to how to avoid the error with the condensed code above? Thanks!
Bookmarks