Access worksheet with the same name as cell value

Hi all

I am trying to use the following code but am getting an error and cannot see where I am going wrong:

Please Login or Register  to view this content.

The code copies a cell and activates a new workbook and worksheet and drops the value onto said sheet (in this case Autofill Information). This works up to this point. I then need to activate a sheet with the same name as the value of cell C3 (i.e. the copied value). I cannot see why my code won't do it, any takers???

Thanks
Ash

Hi,

Your code looks basically OK as long as C3 doesn't contain a number.

You didn't say what the error is. If it's a subscript out of range error, then the value in the cell is not a worksheet name.

@Fotis1991,

Thank you!

My welcoming the new Member to the Forum, could have remained though.

Kind Regards.