Help!

pm · May 10th, 2002, 07:37 AM

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

Mark O'Brien · May 10th, 2002, 08:09 AM

See your other post.

May 10th, 2002, 08:09 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	See your other post. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 07:37 AM	#1
pm New Member Join Date: Apr 2002 Posts: 19	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