Thanks for your reply ... I have set a range named "Database" but its the seconderrori.e. 'Method 'Range of object'_Worksheet failed ' which is causing problems.If you can't help thats ok.