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:

sheet1.select
works great

however when I get to:
sheet2.select
I get an error??

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

...
Workbooks(MyFile).Activate

'Sheet1
Sheet1.Activate
Dim EndRng, Rng, Rng2 As Range

Set Rng = ActiveSheet.Range("N3:N" & Sheet1.Range("L50000").End(xlUp).Row)


Range("N3").Select
ActiveCell.Value = "=D3&F3"
ActiveCell.Select
ActiveCell.Copy
    Rng.Select
    ActiveSheet.Paste
    Application.CutCopyMode = False

'Sheet2
sheet2.Select    'Error at this line      Runtime 424 - Object Required
...

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

Thanks in advance