![]() This shows that we are trying to select that sheet which doesn’t exist. ![]() As we have only one line of code, we can directly run the code by clicking on the play button below the menu bar. We will get an error Message saying “ Run-Time error 9, Subscript out of range” in the VBA as shown below. Now compile the complete code or do it step by step to know which part of the code is an error. ![]() Which means, we are selecting Sheet sequence of 2 nd position with Select function. ![]() ![]() Now go to VBA window and write Sheets(2) followed by Select function as shown below. But we will write a code to select a sheet which is not even added and see what happens.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |