Range Issue

Hi everyone,

I was wondering if someone could help me.

I have 3 workbooks, I have a sheet that will have a button on it that will run the code, when the button is pushed, data from another workbook will then copy to a 3rd workbook.

Control.xls - Has the button, which will run the vba code.
Source.xls - Has the data to be copied.
Dest.xls - Were the data will be copied too.

This is the code I have so far:

Please Login or Register  to view this content.

I get the error "Select method of Range class failed". Can someone tell me where I am going wrong?

Thanks

Any questions just ask.

Hard to tell without knowing the values of LastRow and LastColumn.

Try using the Cells method rather than converting column to a character.

Please Login or Register  to view this content.

Also no need to select.

Use objects rather than rely on the active ones.

Please Login or Register  to view this content.

I couldn't check you actual code as I did not have example data files.
I therefore assumed the code you posted was at least compiling if not running as expected.

The problem is the Pastespecial arguments you posted are for a Range object. Where as they code suggested you where using a worksheet object.

You need to make this change

Please Login or Register  to view this content.