worksheets variables from another sub not working

Hey!

NVM I SOLVED it, apparantly I declared sheetz as a string when it was actually a int! Thanks

I have two subs, when taking a variable (sheetz)from predict1 to predict and using it within worksheets(variable) it doesn't work. However if I declare sheetz within the same sub (predict) it works fine.

Following does not work:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Following works:

Please Login or Register  to view this content.

This also works:

Please Login or Register  to view this content.

I've got about 10 different predict (predict1, predict2) etc subs with different values so I need it to work.
Note that other transfered values works just fine it's only the worksheet that doesn't.
The code is much shorter I've just simplified it to project the single problem.

Thank you!!

Hi,
in my opinion, the problem is that you declare Sheetz argument of sub predict to be of type string. So, when you call Worksheets(sheetz) it is looking for a sheet named 1 and not for the first sheet in the workbook.
Change the declaration to be

Please Login or Register  to view this content.

and I think it will work.

By the way, my personal preference is not to use variables with the same name...

Buran