Hi

I have multiple sheets with the names Payrolldata_Companyname (the company name is different for each sheet)

On a sheet called EmailList i have a list of the company names. Part of my macro is giving the cell containing the company im working on a Named Range of CompanyName. For example i might have company in the list called ExcelForum, which is in Cell A12. Cell A12 has been named CompanyName.

I want my macro to select the Sheet called PayrollData_ExcelForum, by getting the ExcelForum part of the sheet name by referencing the Range CompanyName.

My current link of code for this is as follows

Worksheets("Payrolldata_" & (Sheets("EmailList").Range("CompanyName").Value)).Select

This does not work. Any suggestions?

Thanks