copying ranges from different workbook
 

Mike

I tried the first method you mentioned (the one without using marco) but
due to the nature of the links excel couldnt perform its usual
sequencing effect, it just repeated the values i selected to drag. But
no matter as i've used an adapted verison of the code you wrote and now
it works fine.

Thanks for the help and guidance.

Phillip





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!