Code running on wrong sheet.

You do not need to use "Active". Active is the default value.

With Sheets(i) is the active sheet, but your cursor has to be on the active sheet before you run your code as you have not specified the sheet name. VBA assumes the active sheet happen to be where ever the cursor is.

Do you need to count the sheets? You can just loop through each one like below?

I had learned also if you want to call a variable name in a Macro Call, you need use Application.Run as well

Perhaps try this?

Please Login or Register  to view this content.

Thanks for all your assistance, I think I understand it a little better now.

Originally Posted by ptmuldoon

Do you need to count the sheets?

I don't need to count sheets, I am in the process of rewriting some code and counting the sheets was required in my old code.
Thanks.

Originally Posted by Norie

Try changing cch45_parse to take a sheet as an argument and make sure you reference the passed sheet properly in the sub's code.

You mean like?

Please Login or Register  to view this content.

The first line of my code for cch45_parse sets the worksheet variable

Please Login or Register  to view this content.

, the rest of the the code is

Please Login or Register  to view this content.

but that wasn't giving the desired result.

Originally Posted by Norie

Can you post the code for cch45_parse?

The code for cch45_parse is simply just find and replace 150 different text strings.