Saving excel sheets to folder - problem with Dim sFile ect

Hi,

I have a code that needs to unhide a sheet, check that a certain cell has a value, if it does then check another cell for a certain work then save the sheet in to a folder that is called that same word.

The problem I have it, when I use the

Please Login or Register  to view this content.

code to set the cell references, it only sets them for that sheet, therefore saves them all in to the same folder, I have 100 sheets that each need to be sorted in to each folder.

this is part of the code:

Please Login or Register  to view this content.

Could anyone help me to get this to check each sheet rather than just the first sheet?

Thanks

Katy

Originally Posted by Izandol

You may try:

Please Login or Register  to view this content.

That doesn't seem to work. I have other sheets in the workbook that I do not want to refer to, I just want to refer to (sheet) up to (sheet (99))