![]() ![]() For example, if you want to freeze columns in multiple worksheets for all the worksheets in your workbook, then the VBA method would be helpful. Note: VBA method to freeze rows or columns in Excel is suitable only when you have to do this quite often. In case you want to freeze multiple columns in all the worksheets in your workbook, you can use the below code: 'Code developed by Sumit Bansal from You can also modify the above code to freeze one to multiple rows as well (or both rows and columns) In case you want to freeze the first two columns, you can use Columns(“C:C”).Select ![]() In the above code, I wanted to freeze the first three columns, so I used Columns(“D:D”).Select in my code. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |