Many thanks for your help MTB, I'm still quite a novie when it comes to using macros.

I have used the code you supplied and unfortunatly i'm experencing a run time error "Applicatio n-defined or object-defined error" on the line:

Range("A2").Sel ect

To try to get around this I changed it to:

Worksheets("She et2").Range("A2 ") = Activecell

...

I know that this should be rather simple but i seem to be missing a step to get it to work. and have been unable to find a solution on the net.

The aim is that I click on the open button to find and open an unknown workbook that contains the data that I need to imput into my current workbook, once the unknown workbook is opened it should automatically select my range (number of columns known, but number of rows unknown- the number...