Simple sheet Selection from another workbook using codename

[karl1985]

Hello all,

Really pulling my hair out at the simplest of things today!!

I've essentially got my macro and a form in my personal workbook.

When the code is run, the userform loads with a list box with the open workbooks to select the workbook that the Macro needs to be run in.

As I do not know what the worksheet names are likely to be, all I am trying to do is reference the worksheet code names as the identifier.

so as you can imagine:

Please Login or Register  to view this content.

works great

however when I get to:

Please Login or Register  to view this content.

I get an error??

Why would this happen? this should be simple cod but errors are causing my hair loss!

Please Login or Register  to view this content.

can anyone help with this.... should be simple.... in fact I know it must be!

Thanks in advance

[karl1985]

Scouring the internet it seems that you can't reference a sheet code name from another workbook (where the macro is stored).

[Norie]

Why are you using the sheet names?

Have you tried adding a workbook reference to make sure the code is looking at the correct workbook?

Also, what is the code actually doing?

PS If you can't reference a sheet by codename from another workbook why does the code work for Sheet1?