In Excel, there is limitation for number of Rows and Columns based on the version of MS Office installed in your machine. But there is no limit explicitly defined. It can vary based on the Memory available in your system.
In this article, We will learn how to read worksheet names in a Excel workbook and how to insert a Hyperlink through Excel Macro.
Assume, some user has created more than 100 sheets in a excel workbook. How are we going to choose the desired sheet? One built in method is to right click on the ‘right hand bottom scroll arrows’ in excel workbook. It will show all the sheets in a pop up window and you can choose the sheet that you want to browse.
Note: Above code will generate a entry for Index sheet itself. Customize the above code if you do not want an entry to Index.
This Index sheet will be more useful, if the tab or sheets are with some meaningful names rather than ‘Sheet1’, ‘Sheet2’ and so on. No one will understand the meaning if it has the default names.
Every time, the above code is executed, the Index will get refreshed and if you have manually edited something in index sheet, those data will be erased. So be cautious before hitting the run or execute button to generate the Index.