this is getting to me and am sure you guys will help me.
I have a bunch of worksheets and i usually pass the name of the worksheet as a parameter to do any manipulations to it.
How do i refer to that worksheet by index?
I know if i have the name of the worksheet , i can use the index property by using Worksheets(sheetname).index
I want to avoid using names (I have about 15 worksheets in the workbook)..is there a way out?
thanks in advance
I have a bunch of worksheets and i usually pass the name of the worksheet as a parameter to do any manipulations to it.
How do i refer to that worksheet by index?
I know if i have the name of the worksheet , i can use the index property by using Worksheets(sheetname).index
I want to avoid using names (I have about 15 worksheets in the workbook)..is there a way out?
thanks in advance