replacing sheet("XX").Select with for Loop Worksheet Name

I don't understand what you are trying to do - can you post your actual code?

There shouldn't really ever be a need to select anything

My code is finding the worksheet with the "001" name and creating a pivot table with the range.

But I have to re click on the worksheet so i can convert column F into a number

Please Login or Register  to view this content.

Sorry I still really don't understand what you're trying to do/what the problem is.

There's no need to select anything, maybe:

Please Login or Register  to view this content.

Sorry for being unclear but I am trying to make a universal code that will work with my other excel files. So i can just copy and paste the macro into the files without changing the tab name

Since these are the two tab name for each workbook. So that why I created a for loop to search for 001 in the tab name.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

---------- Post added at 10:01 AM ---------- Previous post was at 10:00 AM ----------

I used the following code below which worked out

Please Login or Register  to view this content.