Hi All;

Hoping someone could help me out with a bit of code...

I have a range from Column A to Column AC but the number of rows changes all the time. I need to copy this range to another excel spreadsheet and have been trying to do this by setting a range name to "MyTable", and then copy it across. I have been trying to use a loop to do this with no success but I fear this is through my lack of understanding when it comes to loops!

Also, When I copy the active workbook across to the other excel s/sheet I need to turn off the warning that says I am replacing the file.

Any help would be greatly appreciated...