Hi guy's iam new to this Excel VBA Community, I use search for the Access issues and now i am have an problem while runing the macro in Excel.I am using an macro which having the foloing property:

 I got two xls working sheet "Macro","Result". The data which is going to sorted ill be pasted in the marco sheet. When macro is runnig first the format and other processs are doned then the old data in the Result sheet is deleted (i.e.) that is the whole sheet is deleted from the Xls file and new sheet is instered and renamed as result by macro. It show error while the new sheet name is deducting different . Iam not intrested in deleting the data in the result Xls worksheet . I want to delete the work sheet itself.

 pls help me in this issue..
 Thanks in advance......:)
Bye


P.A.P.Raguv

Can you post yoru actual macro, it should be faily simple to sort out. I suspect its having a problem knowing which sheet to actually rename once you create a new one but without seeing your code I can only guess.

ni,

i'm lost too. well, mind to post your code?

ix